DBA Data[Home] [Help]

APPS.ICX_GET dependencies on PO_REQUISITION_HEADERS

Line 81: from po_requisition_headers prh

77: select decode(x_type, 'ITEM_COUNT', count(prl.item_id)
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'