APPS.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on OE_ORDER_LINES_ALL

Line 578: -- oe_order_lines_all table.

574: -- To get the from and to organizations depending on what the FOB
575: -- is, we need to join back to the purchase order requisition lines
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,

Line 606: oe_order_lines_all oola,

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,
606: oe_order_lines_all oola,
607: po_requisition_lines_all req,
608: ic_whse_mst whse_mst,
609: mtl_system_items_b msi,
610: ic_item_mst_b ic_item,