APPS.OPI_DBI_OPM_COGS_PKG dependencies on IC_TRAN_PND

Line 82: -- it might be the initial load. check min(trans_date) in ic_tran_pnd

78: l_to_date := sysdate;
79:
80:
81: -- IF l_from_date = global_start_date THEN
82: -- it might be the initial load. check min(trans_date) in ic_tran_pnd
83:
84: -- l_from_date:= Greatest(l_from_date, l_inception_date);
85: -- END IF;
86:

Line 283: from ic_tran_pnd tran,

279: rcv.oe_order_line_id oe_order_line_id,
280: tran.line_id,
281: tran.orgn_code,
282: tran.whse_code
283: from ic_tran_pnd tran,
284: rcv_transactions rcv
285: where doc_type = 'PORC'
286: and completed_ind = 1
287: and gl_posted_ind = 0

Line 310: from ic_tran_pnd tran

306: tran.line_id oe_order_line_id,
307: tran.line_id,
308: tran.orgn_code,
309: tran.whse_code
310: from ic_tran_pnd tran
311: where doc_type = 'OMSO'
312: and completed_ind = 1
313: and gl_posted_ind = 0
314: group by doc_type, line_id, line_id, orgn_code, whse_code

Line 421: from ic_tran_pnd tran,

417: rcv.oe_order_line_id oe_order_line_id,
418: tran.line_id,
419: tran.orgn_code,
420: tran.whse_code
421: from ic_tran_pnd tran,
422: rcv_transactions rcv
423: where doc_type = 'PORC'
424: and completed_ind = 1
425: and gl_posted_ind = 1

Line 448: from ic_tran_pnd tran

444: tran.line_id oe_order_line_id,
445: tran.line_id,
446: tran.orgn_code,
447: tran.whse_code
448: from ic_tran_pnd tran
449: where doc_type = 'OMSO'
450: and completed_ind = 1
451: and gl_posted_ind = 1
452: group by doc_type, line_id, line_id, orgn_code, whse_code

Line 844: from ic_tran_pnd tran,

840: rcv.oe_order_line_id oe_order_line_id,
841: tran.line_id,
842: tran.orgn_code,
843: tran.whse_code
844: from ic_tran_pnd tran,
845: rcv_transactions rcv
846: where doc_type = 'PORC'
847: and completed_ind = 1
848: and gl_posted_ind = 0

Line 873: from ic_tran_pnd tran

869: tran.line_id oe_order_line_id,
870: tran.line_id,
871: tran.orgn_code,
872: tran.whse_code
873: from ic_tran_pnd tran
874: where doc_type = 'OMSO'
875: and completed_ind = 1
876: and gl_posted_ind = 0
877: group by doc_type, line_id, line_id, orgn_code, whse_code

Line 1019: from ic_tran_pnd tran,

1015: rcv.oe_order_line_id oe_order_line_id,
1016: tran.line_id,
1017: tran.orgn_code,
1018: tran.whse_code
1019: from ic_tran_pnd tran,
1020: rcv_transactions rcv
1021: where doc_type = 'PORC'
1022: and completed_ind = 1
1023: and gl_posted_ind = 1

Line 1048: from ic_tran_pnd tran

1044: tran.line_id oe_order_line_id,
1045: tran.line_id,
1046: tran.orgn_code,
1047: tran.whse_code
1048: from ic_tran_pnd tran
1049: where doc_type = 'OMSO'
1050: and completed_ind = 1
1051: and gl_posted_ind = 1
1052: group by doc_type, line_id, line_id, orgn_code, whse_code