Monday 3 June 2013

could you please provide the ouput of HTMomse11i for SO# 1063986 .


SQL> show user
USER is "APPS"
SQL> select name from v$database;

NAME
---------
EBSOLTP1

SQL> @HTMomse11i.sql

Please enter Sales Order number: 1063986

HEADER_ID ORDER_TYPE_NAME CATEGORY ORG_ID ORGANIZATION_NAME
========= ========================= ======== ====== ==============================
1253746 PS_SERV_IC_Parts_MEA ORDER 103 OU_WE_DE


Please enter HEADER_ID from list above (opt):


LINE_ID LINE_NUM ITEM ORD_QTY LINE_CTG ARRIV_SET_ID SHIP_SET_ID LINE_SET_ID
========= ======== ================= ========== ========= ============ =========== ===========
2864524 1.1 T56779400910 9 ORDER &nbsp &nbsp 6453144
2864525 1.2 T56779400910 1 ORDER &nbsp &nbsp 6453144
2864549 2.1 104W1135P059 4 ORDER &nbsp &nbsp &nbsp


Please enter LINE_ID from list above(opt):

Do you want validation performed on this order (Default=Y):
.
.
.
.
it will run for some minutes and generate an HTML report.
.
.
.



SQL> exit

it will generate an HTML report in the current directory.

[oraoltp cstsp ]$ ls -ltrh /u01/oracle/HTMomse11i_1063986.html
-rw-r--r-- 1 oraoltp1 dbaoltp1 1.6M May 29 22:42 /u01/oracle/HTMomse11i_1063986.html

No comments:

Post a Comment