APPS.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on IC_TRAN_CMP

Line 243: ic_tran_cmp t

239: SELECT t.item_id, t.whse_code, -t.trans_qty
240: FROM
241: opi_dbi_inv_value_log sd,
242: sy_orgn_mst o,
243: ic_tran_cmp t
244: WHERE
245: sd.type = 'OID'
246: AND o.organization_id = sd.organization_id
247: AND t.co_code = o.orgn_code

Line 561: -- for everything in the ic_tran_cmp

557: sy_orgn_mst o,
558: opi_dbi_inv_value_log sd
559: WHERE pnd.completed_ind = 1 -- completed transfer
560: -- view sets completed_ind to 1
561: -- for everything in the ic_tran_cmp
562: AND pnd.doc_type = 'XFER' -- inventory transfer
563: AND pnd.doc_id = xfer.transfer_id
564: AND o.orgn_code = pnd.co_code
565: AND sd.type = 'OID'

Line 601: FROM ic_tran_cmp

597: SELECT doc_type, doc_id, line_id, co_code, whse_code, item_id,
598: sum (trans_qty) trans_qty, trans_um, gl_posted_ind,
599: trans_date,
600: 1 -- all transactions are completed in tran_cmp
601: FROM ic_tran_cmp
602: WHERE doc_type = 'OMSO'
603: GROUP BY doc_type, doc_id, line_id, co_code, whse_code, item_id,
604: trans_um, gl_posted_ind, trans_date, 1
605: ) ic_tran,

Line 657: FROM ic_tran_cmp

653: SELECT doc_type, doc_id, line_id, co_code, whse_code, item_id,
654: sum (trans_qty) trans_qty, trans_um, gl_posted_ind,
655: trans_date,
656: 1 -- all transactions are completed in tran_cmp
657: FROM ic_tran_cmp
658: WHERE doc_type = 'PORC'
659: GROUP BY doc_type, doc_id, line_id, co_code, whse_code, item_id,
660: trans_um, gl_posted_ind, trans_date, 1
661: ) ic_tran,