DBA Data[Home] [Help]

APPS.CSP_PLANNER_NOTIFICATIONS dependencies on PO_REQUISITION_LINES_ALL

Line 869: po_requisition_lines_all pol

865: BEGIN
866: SELECT sum(pol.quantity)
867: INTO l_supply_qty
868: FROM po_requisition_headers_all poh,
869: po_requisition_lines_all pol
870: WHERE poh.authorization_status = 'INCOMPLETE'
871: AND pol.requisition_header_id = poh.requisition_header_id
872: AND pol.destination_type_code = 'INVENTORY'
873: AND pol.item_id = l_item_id