APPS.OPI_DBI_OPM_COGS_PKG dependencies on IC_TRAN_CMP

Line 297: from ic_tran_cmp tran,

293: rcv.oe_order_line_id oe_order_line_id,
294: tran.line_id,
295: tran.orgn_code,
296: tran.whse_code
297: from ic_tran_cmp tran,
298: rcv_transactions rcv
299: where doc_type = 'PORC'
300: and gl_posted_ind = 0
301: and tran.line_id = rcv.transaction_id

Line 321: from ic_tran_cmp tran

317: tran.line_id oe_order_line_id,
318: tran.line_id,
319: tran.orgn_code,
320: tran.whse_code
321: from ic_tran_cmp tran
322: where doc_type = 'OMSO'
323: and gl_posted_ind = 0
324: group by doc_type, line_id, line_id, orgn_code, whse_code ) tran
325: where tst.doc_type in ( 'OMSO', 'PORC' )

Line 435: from ic_tran_cmp tran,

431: rcv.oe_order_line_id oe_order_line_id,
432: tran.line_id,
433: tran.orgn_code,
434: tran.whse_code
435: from ic_tran_cmp tran,
436: rcv_transactions rcv
437: where doc_type = 'PORC'
438: and gl_posted_ind = 1
439: and tran.line_id = rcv.transaction_id

Line 459: from ic_tran_cmp tran

455: tran.line_id oe_order_line_id,
456: tran.line_id,
457: tran.orgn_code,
458: tran.whse_code
459: from ic_tran_cmp tran
460: where doc_type = 'OMSO'
461: and gl_posted_ind = 1
462: group by doc_type, line_id, line_id, orgn_code, whse_code ) tran
463: where tst.doc_type in ( 'OMSO', 'PORC' )

Line 859: from ic_tran_cmp tran,

855: rcv.oe_order_line_id oe_order_line_id,
856: tran.line_id,
857: tran.orgn_code,
858: tran.whse_code
859: from ic_tran_cmp tran,
860: rcv_transactions rcv
861: where doc_type = 'PORC'
862: and gl_posted_ind = 0
863: and tran.line_id = rcv.transaction_id

Line 885: from ic_tran_cmp tran

881: tran.line_id oe_order_line_id,
882: tran.line_id,
883: tran.orgn_code,
884: tran.whse_code
885: from ic_tran_cmp tran
886: where doc_type = 'OMSO'
887: and gl_posted_ind = 0
888: group by doc_type, line_id, line_id, orgn_code, whse_code ) tran
889: where tst.doc_type in ( 'OMSO', 'PORC' )

Line 1034: from ic_tran_cmp tran,

1030: rcv.oe_order_line_id oe_order_line_id,
1031: tran.line_id,
1032: tran.orgn_code,
1033: tran.whse_code
1034: from ic_tran_cmp tran,
1035: rcv_transactions rcv
1036: where doc_type = 'PORC'
1037: and gl_posted_ind = 1
1038: and tran.line_id = rcv.transaction_id

Line 1060: from ic_tran_cmp tran

1056: tran.line_id oe_order_line_id,
1057: tran.line_id,
1058: tran.orgn_code,
1059: tran.whse_code
1060: from ic_tran_cmp tran
1061: where doc_type = 'OMSO'
1062: and gl_posted_ind = 1
1063: group by doc_type, line_id, line_id, orgn_code, whse_code ) tran
1064: where tst.doc_type in ( 'OMSO', 'PORC' )