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.OPI_DBI_COGS_PKG dependencies on OE_ORDER_LINES_ALL

Line 296: oe_order_lines_all lines, -- child line

292: decode(p_lines.order_source_id,10,1,0)
293: FROM opi_dbi_conc_prog_run_log log,
294: mtl_material_transactions mmt,
295: mtl_transaction_accounts mta,
296: oe_order_lines_all lines, -- child line
297: oe_order_lines_all p_lines, -- parent line
298: oe_order_headers_all header,
299: hz_cust_accounts cust_acct,
300: mtl_system_items_b item

Line 297: oe_order_lines_all p_lines, -- parent line

293: FROM opi_dbi_conc_prog_run_log log,
294: mtl_material_transactions mmt,
295: mtl_transaction_accounts mta,
296: oe_order_lines_all lines, -- child line
297: oe_order_lines_all p_lines, -- parent line
298: oe_order_headers_all header,
299: hz_cust_accounts cust_acct,
300: mtl_system_items_b item
301: WHERE mmt.transaction_id >= log.from_bound_id

Line 341: oe_order_lines_all lines, -- child line

337: 0
338: FROM opi_dbi_conc_prog_run_log log,
339: mtl_material_transactions mmt,
340: mtl_transaction_accounts mta,
341: oe_order_lines_all lines, -- child line
342: oe_order_lines_all l_lines, -- linking line
343: oe_order_lines_all p_lines, -- parent line
344: oe_order_headers_all header,
345: hz_cust_accounts cust_acct,

Line 342: oe_order_lines_all l_lines, -- linking line

338: FROM opi_dbi_conc_prog_run_log log,
339: mtl_material_transactions mmt,
340: mtl_transaction_accounts mta,
341: oe_order_lines_all lines, -- child line
342: oe_order_lines_all l_lines, -- linking line
343: oe_order_lines_all p_lines, -- parent line
344: oe_order_headers_all header,
345: hz_cust_accounts cust_acct,
346: mtl_system_items_b item

Line 343: oe_order_lines_all p_lines, -- parent line

339: mtl_material_transactions mmt,
340: mtl_transaction_accounts mta,
341: oe_order_lines_all lines, -- child line
342: oe_order_lines_all l_lines, -- linking line
343: oe_order_lines_all p_lines, -- parent line
344: oe_order_headers_all header,
345: hz_cust_accounts cust_acct,
346: mtl_system_items_b item
347: WHERE mmt.transaction_id >= log.from_bound_id

Line 387: oe_order_lines_all lines,

383: FROM opi_dbi_conc_prog_run_log log,
384: mtl_material_transactions mmt,
385: mtl_material_transactions p_mmt,
386: mtl_transaction_accounts mta,
387: oe_order_lines_all lines,
388: oe_order_lines_all p_lines, -- parent line
389: oe_order_headers_all header,
390: hz_cust_accounts cust_acct,
391: mtl_system_items_b item

Line 388: oe_order_lines_all p_lines, -- parent line

384: mtl_material_transactions mmt,
385: mtl_material_transactions p_mmt,
386: mtl_transaction_accounts mta,
387: oe_order_lines_all lines,
388: oe_order_lines_all p_lines, -- parent line
389: oe_order_headers_all header,
390: hz_cust_accounts cust_acct,
391: mtl_system_items_b item
392: WHERE mmt.transaction_id >= log.from_bound_id

Line 489: oe_order_lines_all lines, -- child line

485: decode(p_lines.order_source_id,10,1,0)
486: FROM opi_dbi_conc_prog_run_log log,
487: mtl_material_transactions mmt,
488: mtl_transaction_accounts mta,
489: oe_order_lines_all lines, -- child line
490: oe_order_lines_all p_lines, -- parent line
491: oe_order_headers_all header,
492: hz_cust_accounts cust_acct,
493: mtl_system_items_b item

Line 490: oe_order_lines_all p_lines, -- parent line

486: FROM opi_dbi_conc_prog_run_log log,
487: mtl_material_transactions mmt,
488: mtl_transaction_accounts mta,
489: oe_order_lines_all lines, -- child line
490: oe_order_lines_all p_lines, -- parent line
491: oe_order_headers_all header,
492: hz_cust_accounts cust_acct,
493: mtl_system_items_b item
494: WHERE mmt.transaction_id >= log.from_bound_id

Line 530: oe_order_lines_all lines, -- child line

526: 0
527: FROM opi_dbi_conc_prog_run_log log,
528: mtl_material_transactions mmt,
529: mtl_transaction_accounts mta,
530: oe_order_lines_all lines, -- child line
531: oe_order_lines_all l_lines, -- linking line
532: oe_order_lines_all p_lines, -- parent line
533: oe_order_headers_all header,
534: hz_cust_accounts cust_acct,

Line 531: oe_order_lines_all l_lines, -- linking line

527: FROM opi_dbi_conc_prog_run_log log,
528: mtl_material_transactions mmt,
529: mtl_transaction_accounts mta,
530: oe_order_lines_all lines, -- child line
531: oe_order_lines_all l_lines, -- linking line
532: oe_order_lines_all p_lines, -- parent line
533: oe_order_headers_all header,
534: hz_cust_accounts cust_acct,
535: mtl_system_items_b item

Line 532: oe_order_lines_all p_lines, -- parent line

528: mtl_material_transactions mmt,
529: mtl_transaction_accounts mta,
530: oe_order_lines_all lines, -- child line
531: oe_order_lines_all l_lines, -- linking line
532: oe_order_lines_all p_lines, -- parent line
533: oe_order_headers_all header,
534: hz_cust_accounts cust_acct,
535: mtl_system_items_b item
536: WHERE mmt.transaction_id >= log.from_bound_id

Line 573: oe_order_lines_all lines,

569: FROM opi_dbi_conc_prog_run_log log,
570: mtl_material_transactions mmt,
571: mtl_material_transactions p_mmt,
572: mtl_transaction_accounts mta,
573: oe_order_lines_all lines,
574: oe_order_lines_all p_lines, -- parent line
575: oe_order_headers_all header,
576: hz_cust_accounts cust_acct,
577: mtl_system_items_b item

Line 574: oe_order_lines_all p_lines, -- parent line

570: mtl_material_transactions mmt,
571: mtl_material_transactions p_mmt,
572: mtl_transaction_accounts mta,
573: oe_order_lines_all lines,
574: oe_order_lines_all p_lines, -- parent line
575: oe_order_headers_all header,
576: hz_cust_accounts cust_acct,
577: mtl_system_items_b item
578: WHERE mmt.transaction_id >= log.from_bound_id

Line 673: FROM oe_order_lines_all lines, -- child line

669: gtv.transaction_date,
670: OPM_SOURCE,
671: decode(p_lines.source_type_code, 'EXTERNAL', 2, 1 ),
672: decode(p_lines.order_source_id,10,1,0)
673: FROM oe_order_lines_all lines, -- child line
674: oe_order_lines_all p_lines, -- parent line
675: oe_order_headers_all header,
676: hz_cust_accounts cust_acct,
677: mtl_system_items_b item,

Line 674: oe_order_lines_all p_lines, -- parent line

670: OPM_SOURCE,
671: decode(p_lines.source_type_code, 'EXTERNAL', 2, 1 ),
672: decode(p_lines.order_source_id,10,1,0)
673: FROM oe_order_lines_all lines, -- child line
674: oe_order_lines_all p_lines, -- parent line
675: oe_order_headers_all header,
676: hz_cust_accounts cust_acct,
677: mtl_system_items_b item,
678: (

Line 727: FROM oe_order_lines_all lines, -- child line

723: gtv.transaction_date,
724: OPM_SOURCE,
725: 1,
726: 0
727: FROM oe_order_lines_all lines, -- child line
728: oe_order_lines_all l_lines, -- linking line
729: oe_order_lines_all p_lines, -- parent line
730: oe_order_headers_all header,
731: hz_cust_accounts cust_acct,

Line 728: oe_order_lines_all l_lines, -- linking line

724: OPM_SOURCE,
725: 1,
726: 0
727: FROM oe_order_lines_all lines, -- child line
728: oe_order_lines_all l_lines, -- linking line
729: oe_order_lines_all p_lines, -- parent line
730: oe_order_headers_all header,
731: hz_cust_accounts cust_acct,
732: mtl_system_items_b item,

Line 729: oe_order_lines_all p_lines, -- parent line

725: 1,
726: 0
727: FROM oe_order_lines_all lines, -- child line
728: oe_order_lines_all l_lines, -- linking line
729: oe_order_lines_all p_lines, -- parent line
730: oe_order_headers_all header,
731: hz_cust_accounts cust_acct,
732: mtl_system_items_b item,
733: (

Line 784: FROM oe_order_lines_all lines, -- child line

780: gtv.transaction_date,
781: OPM_SOURCE,
782: 1,
783: 0
784: FROM oe_order_lines_all lines, -- child line
785: oe_order_lines_all p_lines, -- parent line
786: oe_order_headers_all header,
787: hz_cust_accounts cust_acct,
788: mtl_system_items_b item,

Line 785: oe_order_lines_all p_lines, -- parent line

781: OPM_SOURCE,
782: 1,
783: 0
784: FROM oe_order_lines_all lines, -- child line
785: oe_order_lines_all p_lines, -- parent line
786: oe_order_headers_all header,
787: hz_cust_accounts cust_acct,
788: mtl_system_items_b item,
789: mtl_material_transactions mmt,

Line 1049: oe_order_lines_all lines, -- child line

1045: gtv.inventory_item_id,
1046: gtv.organization_id,
1047: gtv.line_id,
1048: gtv.transaction_date) gtv,
1049: oe_order_lines_all lines, -- child line
1050: oe_order_lines_all p_lines, -- parent line
1051: oe_order_headers_all header,
1052: hz_cust_accounts cust_acct,
1053: mtl_system_items_b item

Line 1050: oe_order_lines_all p_lines, -- parent line

1046: gtv.organization_id,
1047: gtv.line_id,
1048: gtv.transaction_date) gtv,
1049: oe_order_lines_all lines, -- child line
1050: oe_order_lines_all p_lines, -- parent line
1051: oe_order_headers_all header,
1052: hz_cust_accounts cust_acct,
1053: mtl_system_items_b item
1054: WHERE lines.line_id = gtv.line_id

Line 1128: oe_order_lines_all lines, -- child line

1124: gtv.inventory_item_id,
1125: gtv.organization_id,
1126: gtv.line_id,
1127: gtv.transaction_date) gtv,
1128: oe_order_lines_all lines, -- child line
1129: oe_order_lines_all l_lines, -- linking line
1130: oe_order_lines_all p_lines, -- parent line
1131: oe_order_headers_all header,
1132: hz_cust_accounts cust_acct,

Line 1129: oe_order_lines_all l_lines, -- linking line

1125: gtv.organization_id,
1126: gtv.line_id,
1127: gtv.transaction_date) gtv,
1128: oe_order_lines_all lines, -- child line
1129: oe_order_lines_all l_lines, -- linking line
1130: oe_order_lines_all p_lines, -- parent line
1131: oe_order_headers_all header,
1132: hz_cust_accounts cust_acct,
1133: mtl_system_items_b item

Line 1130: oe_order_lines_all p_lines, -- parent line

1126: gtv.line_id,
1127: gtv.transaction_date) gtv,
1128: oe_order_lines_all lines, -- child line
1129: oe_order_lines_all l_lines, -- linking line
1130: oe_order_lines_all p_lines, -- parent line
1131: oe_order_headers_all header,
1132: hz_cust_accounts cust_acct,
1133: mtl_system_items_b item
1134: WHERE lines.line_id = gtv.line_id

Line 1214: oe_order_lines_all lines, -- child line

1210: gtv.line_id,
1211: gtv.transaction_date) gtv,
1212: mtl_material_transactions mmt,
1213: mtl_material_transactions p_mmt,
1214: oe_order_lines_all lines, -- child line
1215: oe_order_lines_all p_lines, -- parent line
1216: oe_order_headers_all header,
1217: hz_cust_accounts cust_acct,
1218: mtl_system_items_b item

Line 1215: oe_order_lines_all p_lines, -- parent line

1211: gtv.transaction_date) gtv,
1212: mtl_material_transactions mmt,
1213: mtl_material_transactions p_mmt,
1214: oe_order_lines_all lines, -- child line
1215: oe_order_lines_all p_lines, -- parent line
1216: oe_order_headers_all header,
1217: hz_cust_accounts cust_acct,
1218: mtl_system_items_b item
1219: WHERE gtv.transaction_id = mmt.transaction_id