DBA Data[Home] [Help]

APPS.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on RCV_TRANSACTIONS

Line 580: -- rcv_transactions table.

576: -- table, po_requisitions_lines_all.
577: -- For shipments (doc_type = OMSO) this is achieved through the
578: -- oe_order_lines_all table.
579: -- For receipts (doc_type = PORC) this is achieved through the
580: -- rcv_transactions table.
581: SELECT whse_mst.whse_code whse,
582: ic_item.item_id item,
583: (-1 * ic_tran.trans_qty) qty
584: FROM (SELECT doc_type, doc_id, line_id, co_code, whse_code, item_id,

Line 662: rcv_transactions rcv,

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,
662: rcv_transactions rcv,
663: po_requisition_lines_all req,
664: ic_whse_mst whse_mst,
665: mtl_system_items_b msi,
666: ic_item_mst_b ic_item,