eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BULK_VALIDATE dependencies on OE_LINES_IFACE_ALL

Line 162: FROM OE_HEADERS_IFACE_ALL h, OE_LINES_IFACE_ALL l

158: ,660 ,NULL ,NULL
159: ,NULL ,NULL ,NULL
160: ,'C' ,USERENV('LANG')
161: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
162: FROM OE_HEADERS_IFACE_ALL h, OE_LINES_IFACE_ALL l
163: WHERE h.batch_id = p_batch_id
164: AND h.order_source_id = l.order_source_id
165: AND h.orig_sys_document_ref = l.orig_sys_document_ref
166: AND l.orig_sys_line_ref IS NULL

Line 201: FROM OE_HEADERS_IFACE_ALL h, OE_LINES_IFACE_ALL l

197: ,660 ,NULL ,NULL
198: ,NULL ,NULL ,NULL
199: ,'C' ,USERENV('LANG')
200: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
201: FROM OE_HEADERS_IFACE_ALL h, OE_LINES_IFACE_ALL l
202: WHERE h.batch_id = p_batch_id
203: AND h.order_source_id = l.order_source_id
204: AND h.orig_sys_document_ref = l.orig_sys_document_ref
205: AND ( nvl(l.source_type_code,'INTERNAL') <> 'INTERNAL' -- Drop ships

Line 389: FROM OE_LINES_IFACE_ALL b

385: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ACCOUNTING_RULE_ID'
386: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
387: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
388: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
389: FROM OE_LINES_IFACE_ALL b
390: WHERE (order_source_id, orig_sys_document_ref) IN
391: ( SELECT order_source_id, orig_sys_document_ref
392: FROM OE_HEADERS_IFACE_ALL
393: WHERE batch_id = p_batch_id)

Line 520: FROM OE_LINES_IFACE_ALL b

516: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'DEMAND_CLASS_CODE'
517: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
518: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
519: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
520: FROM OE_LINES_IFACE_ALL b
521: WHERE (order_source_id, orig_sys_document_ref) IN
522: ( SELECT order_source_id, orig_sys_document_ref
523: FROM OE_HEADERS_IFACE_ALL
524: WHERE batch_id = p_batch_id)

Line 620: FROM OE_LINES_IFACE_ALL b

616: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'FOB_POINT_CODE'
617: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
618: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
619: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
620: FROM OE_LINES_IFACE_ALL b
621: WHERE (order_source_id, orig_sys_document_ref) IN
622: ( SELECT order_source_id, orig_sys_document_ref
623: FROM OE_HEADERS_IFACE_ALL
624: WHERE batch_id = p_batch_id)

Line 701: FROM OE_LINES_IFACE_ALL b

697: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'FREIGHT_TERMS_CODE'
698: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
699: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
700: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
701: FROM OE_LINES_IFACE_ALL b
702: WHERE (order_source_id, orig_sys_document_ref) IN
703: ( SELECT order_source_id, orig_sys_document_ref
704: FROM OE_HEADERS_IFACE_ALL
705: WHERE batch_id = p_batch_id)

Line 779: FROM OE_LINES_IFACE_ALL b

775: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'INVOICING_RULE_ID'
776: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
777: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
778: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
779: FROM OE_LINES_IFACE_ALL b
780: WHERE (order_source_id, orig_sys_document_ref) IN
781: ( SELECT order_source_id, orig_sys_document_ref
782: FROM OE_HEADERS_IFACE_ALL
783: WHERE batch_id = p_batch_id)

Line 896: FROM OE_LINES_IFACE_ALL b

892: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'PAYMENT_TERM_ID'
893: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
894: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
895: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
896: FROM OE_LINES_IFACE_ALL b
897: WHERE (order_source_id, orig_sys_document_ref) IN
898: ( SELECT order_source_id, orig_sys_document_ref
899: FROM OE_HEADERS_IFACE_ALL
900: WHERE batch_id = p_batch_id)

Line 973: FROM OE_LINES_IFACE_ALL b

969: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'PRICE_LIST_ID'
970: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
971: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
972: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
973: FROM OE_LINES_IFACE_ALL b
974: WHERE (order_source_id, orig_sys_document_ref) IN
975: ( SELECT order_source_id, orig_sys_document_ref
976: FROM OE_HEADERS_IFACE_ALL
977: WHERE batch_id = p_batch_id)

Line 1051: FROM OE_LINES_IFACE_ALL b

1047: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SHIPMENT_PRIORITY_CODE'
1048: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1049: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1050: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1051: FROM OE_LINES_IFACE_ALL b
1052: WHERE (order_source_id, orig_sys_document_ref) IN
1053: ( SELECT order_source_id, orig_sys_document_ref
1054: FROM OE_HEADERS_IFACE_ALL
1055: WHERE batch_id = p_batch_id)

Line 1129: FROM OE_LINES_IFACE_ALL b

1125: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SHIPPING_METHOD_CODE'
1126: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1127: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1128: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1129: FROM OE_LINES_IFACE_ALL b
1130: WHERE (order_source_id, orig_sys_document_ref) IN
1131: ( SELECT order_source_id, orig_sys_document_ref
1132: FROM OE_HEADERS_IFACE_ALL
1133: WHERE batch_id = p_batch_id)

Line 1206: FROM OE_LINES_IFACE_ALL b

1202: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SOLD_TO_ORG_ID'
1203: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1204: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1205: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1206: FROM OE_LINES_IFACE_ALL b
1207: WHERE (order_source_id, orig_sys_document_ref) IN
1208: ( SELECT order_source_id, orig_sys_document_ref
1209: FROM OE_HEADERS_IFACE_ALL
1210: WHERE batch_id = p_batch_id)

Line 1286: FROM OE_LINES_IFACE_ALL b

1282: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'TAX_EXEMPT_FLAG'
1283: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1284: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1285: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1286: FROM OE_LINES_IFACE_ALL b
1287: WHERE (order_source_id, orig_sys_document_ref) IN
1288: ( SELECT order_source_id, orig_sys_document_ref
1289: FROM OE_HEADERS_IFACE_ALL
1290: WHERE batch_id = p_batch_id)

Line 1459: FROM OE_LINES_IFACE_ALL b

1455: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SALESREP_ID'
1456: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1457: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1458: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1459: FROM OE_LINES_IFACE_ALL b
1460: WHERE (order_source_id, orig_sys_document_ref) IN
1461: ( SELECT order_source_id, orig_sys_document_ref
1462: FROM OE_HEADERS_IFACE_ALL
1463: WHERE batch_id = p_batch_id)

Line 1553: FROM OE_LINES_IFACE_ALL b

1549: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'END_ITEM_UNIT_NUMBER'
1550: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1551: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1552: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1553: FROM OE_LINES_IFACE_ALL b
1554: WHERE (order_source_id, orig_sys_document_ref) IN
1555: ( SELECT order_source_id, orig_sys_document_ref
1556: FROM OE_HEADERS_IFACE_ALL
1557: WHERE batch_id = p_batch_id)

Line 1591: FROM OE_LINES_IFACE_ALL b

1587: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'END_ITEM_UNIT_NUMBER'
1588: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1589: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1590: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1591: FROM OE_LINES_IFACE_ALL b
1592: WHERE (order_source_id, orig_sys_document_ref) IN
1593: ( SELECT order_source_id, orig_sys_document_ref
1594: FROM OE_HEADERS_IFACE_ALL
1595: WHERE batch_id = p_batch_id)

Line 1636: FROM OE_LINES_IFACE_ALL b

1632: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1633: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1634: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1635: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1636: FROM OE_LINES_IFACE_ALL b
1637: WHERE (order_source_id, orig_sys_document_ref) IN
1638: ( SELECT order_source_id, orig_sys_document_ref
1639: FROM OE_HEADERS_IFACE_ALL
1640: WHERE batch_id = p_batch_id)

Line 1682: FROM OE_LINES_IFACE_ALL b

1678: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1679: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1680: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1681: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1682: FROM OE_LINES_IFACE_ALL b
1683: WHERE (order_source_id, orig_sys_document_ref) IN
1684: ( SELECT order_source_id, orig_sys_document_ref
1685: FROM OE_HEADERS_IFACE_ALL
1686: WHERE batch_id = p_batch_id)

Line 1729: FROM OE_LINES_IFACE_ALL b

1725: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1726: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1727: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1728: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1729: FROM OE_LINES_IFACE_ALL b
1730: WHERE (order_source_id, orig_sys_document_ref) IN
1731: ( SELECT order_source_id, orig_sys_document_ref
1732: FROM OE_HEADERS_IFACE_ALL
1733: WHERE batch_id = p_batch_id)

Line 1777: FROM OE_LINES_IFACE_ALL b

1773: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1774: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1775: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1776: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1777: FROM OE_LINES_IFACE_ALL b
1778: WHERE (order_source_id, orig_sys_document_ref) IN
1779: ( SELECT order_source_id, orig_sys_document_ref
1780: FROM OE_HEADERS_IFACE_ALL
1781: WHERE batch_id = p_batch_id)

Line 1830: FROM OE_LINES_IFACE_ALL b

1826: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'PREFERRED_GRADE'
1827: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1828: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1829: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1830: FROM OE_LINES_IFACE_ALL b
1831: WHERE (order_source_id, orig_sys_document_ref) IN
1832: ( SELECT order_source_id, orig_sys_document_ref
1833: FROM OE_HEADERS_IFACE_ALL
1834: WHERE batch_id = p_batch_id)

Line 2237: FROM OE_LINES_IFACE_ALL b

2233: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'END_CUSTOMER_ID'
2234: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2235: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
2236: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2237: FROM OE_LINES_IFACE_ALL b
2238: WHERE (order_source_id, orig_sys_document_ref) IN
2239: ( SELECT order_source_id, orig_sys_document_ref
2240: FROM OE_HEADERS_IFACE_ALL
2241: WHERE batch_id = p_batch_id)

Line 2605: UPDATE OE_LINES_IFACE_ALL c

2601:
2602:
2603: BEGIN
2604:
2605: UPDATE OE_LINES_IFACE_ALL c
2606: SET ATTRIBUTE_STATUS = NULL
2607: WHERE (order_source_id, orig_sys_document_ref) IN
2608: ( SELECT a.order_source_id, a.orig_sys_document_ref
2609: FROM OE_HEADERS_IFACE_ALL a, OE_PROCESSING_MSGS b