DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 3580: FROM po_requisitions_interface_all pria

3576: /*union added for #6118897 to avoid duplicate requisition creation -- start*/
3577: SELECT SUM(nvl(req_qty,0)) INTO l_req_qty
3578: FROM
3579: (SELECT SUM(nvl(quantity,0)) req_qty
3580: FROM po_requisitions_interface_all pria
3581: WHERE pria.wip_entity_id = l_eam_mat_req_rec.wip_entity_id
3582: AND pria.destination_organization_id = l_eam_mat_req_rec.organization_id
3583: AND pria.wip_operation_seq_num = l_eam_mat_req_rec.operation_seq_num
3584: AND pria.item_id = l_eam_mat_req_rec.inventory_item_id

Line 4399: FROM po_requisitions_interface_all pria

4395: /*Added Union for #6118897 to avoid duplicate req creation -- start --*/
4396: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
4397: FROM
4398: (SELECT SUM(nvl(quantity,0)) req_qty
4399: FROM po_requisitions_interface_all pria
4400: WHERE pria.wip_entity_id = l_eam_direct_items_rec.wip_entity_id
4401: AND pria.destination_organization_id = l_eam_direct_items_rec.organization_id
4402: AND pria.wip_operation_seq_num = l_eam_direct_items_rec.operation_seq_num
4403: AND pria.item_id is null