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     6453144
2864525 1.2 T56779400910 1 ORDER     6453144
2864549 2.1 104W1135P059 4 ORDER      
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