DBA Data[Home] [Help]

APPS.EAM_DIRECT_ITEMS_VALIDATE_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 252: wip_eam_direct_items wed, po_requisition_lines_all rql, po_requisition_headers_all rqh

248: wed.description,
249: /*sum(rql.quantity) #6118897 7509781*/
250: sum(Decode(upper(NVL(rqh.authorization_status, 'APPROVED')), 'CANCELLED', 0, 'REJECTED', 0, 'SYSTEM_SAVED',0,rql.quantity)) quantity
251: FROM
252: wip_eam_direct_items wed, po_requisition_lines_all rql, po_requisition_headers_all rqh
253: WHERE
254: wed.wip_entity_id = rql.wip_entity_id (+)
255: AND wed.organization_id = rql.destination_organization_id (+)
256: AND wed.operation_seq_num = rql.wip_operation_seq_num (+)