DBA Data[Home] [Help]

APPS.INV_KANBAN_PVT dependencies on PO_HEADERS

Line 3888: AND (EXISTS (SELECT '1' FROM po_headers poh

3884: FROM po_requisition_lines prl1
3885: WHERE prl1.kanban_card_id = p_kanban_card_id
3886: AND prl1.requisition_line_id = l_max_req
3887: AND prl1.line_location_id IS NOT NULL
3888: AND (EXISTS (SELECT '1' FROM po_headers poh
3889: WHERE EXISTS ( SELECT '1' FROM po_line_locations pll
3890: WHERE pll.line_location_id = prl1.line_location_id
3891: AND pll.po_header_id = poh.po_header_id
3892: AND nvl(poh.authorization_status,'%%') <> 'APPROVED'))