APPS.ICX_GET dependencies on PO_REQUISITION_LINES

Line 82: , po_requisition_lines prl

78: , 'QUANTITY_SUM', sum(prl.quantity)
79: , 'TOTAL_AMOUNT', sum(prl.unit_price*prl.quantity))
80: into x_count_or_sum
81: from po_requisition_headers prh
82: , po_requisition_lines prl
83: where prh.requisition_header_id = prl.requisition_header_id
84: and nvl(prh.authorization_status, 'APPROVE') <> 'INCOMPLETE'
85: and nvl(prh.cancel_flag,'N') <> 'Y'
86: and prl.vendor_id = x_vendor_id