DBA Data[Home] [Help]

APPS.OPI_DBI_PRE_R12_COGS_PKG dependencies on IC_TRAN_PND

Line 94: FROM ic_tran_pnd tran,

90: rcv.oe_order_line_id oe_order_line_id,
91: tran.line_id,
92: tran.orgn_code,
93: tran.whse_code
94: FROM ic_tran_pnd tran,
95: rcv_transactions rcv
96: WHERE doc_type = 'PORC'
97: AND completed_ind = 1
98: AND gl_posted_ind = 1

Line 109: FROM ic_tran_pnd tran

105: tran.line_id oe_order_line_id,
106: tran.line_id,
107: tran.orgn_code,
108: tran.whse_code
109: FROM ic_tran_pnd tran
110: WHERE doc_type = 'OMSO'
111: AND completed_ind = 1
112: AND gl_posted_ind = 1
113: GROUP BY doc_type, line_id, line_id, orgn_code, whse_code) tran,