DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on RCV_SHIPMENT_LINES

Line 4534: rcv_shipment_lines rsl

4530: FROM mtl_system_items_vl a, /* Bug 5581528 */
4531: rcv_transactions_v b,
4532: (SELECT DISTINCT rsl.shipment_header_id
4533: FROM po_requisition_lines pol,
4534: rcv_shipment_lines rsl
4535: WHERE pol.requisition_header_id = p_source_id
4536: AND pol.requisition_line_id = rsl.requisition_line_id
4537: ) shipment
4538: WHERE b.to_organization_id = p_organization_id

Line 4602: rcv_shipment_lines rsl

4598: rcv_transactions_v b,
4599: mtl_cross_references mcr,
4600: (SELECT DISTINCT rsl.shipment_header_id
4601: FROM po_requisition_lines pol,
4602: rcv_shipment_lines rsl
4603: WHERE pol.requisition_header_id = p_source_id
4604: AND pol.requisition_line_id = rsl.requisition_line_id
4605: ) shipment
4606: WHERE b.to_organization_id = p_organization_id