DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on RCV_SHIPMENT_LINES

Line 4806: rcv_shipment_lines rsl

4802: FROM mtl_system_items_vl a, /* Bug 5581528 */
4803: rcv_transactions_v b,
4804: (SELECT DISTINCT rsl.shipment_header_id
4805: FROM po_requisition_lines pol,
4806: rcv_shipment_lines rsl
4807: WHERE pol.requisition_header_id = p_source_id
4808: AND pol.requisition_line_id = rsl.requisition_line_id
4809: ) shipment
4810: WHERE b.to_organization_id = p_organization_id

Line 4875: rcv_shipment_lines rsl

4871: rcv_transactions_v b,
4872: mtl_cross_references mcr,
4873: (SELECT DISTINCT rsl.shipment_header_id
4874: FROM po_requisition_lines pol,
4875: rcv_shipment_lines rsl
4876: WHERE pol.requisition_header_id = p_source_id
4877: AND pol.requisition_line_id = rsl.requisition_line_id
4878: ) shipment
4879: WHERE b.to_organization_id = p_organization_id