APPS.EAM_PROCESS_WO_PVT dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 3608: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/

3604: -- trigger requisition again for the cancelled quantity where the earlier Req/PO was cancelled
3605:
3606: BEGIN
3607:
3608: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/
3609:
3610: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
3611: FROM
3612: (SELECT SUM(nvl(pria.quantity,0)) req_qty

Line 3613: FROM po_requisitions_interface_all pria

3609:
3610: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
3611: FROM
3612: (SELECT SUM(nvl(pria.quantity,0)) req_qty
3613: FROM po_requisitions_interface_all pria
3614: WHERE pria.wip_entity_id = l_eam_mat_req_rec.wip_entity_id
3615: AND pria.destination_organization_id = l_eam_mat_req_rec.organization_id
3616: AND pria.wip_operation_seq_num = l_eam_mat_req_rec.operation_seq_num
3617: AND pria.item_id = l_eam_mat_req_rec.inventory_item_id

Line 3666: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/

3662:
3663: ELSE -- Don't trigger requisition again for the cancelled quantity where the earlier Req/PO was cancelled
3664:
3665: BEGIN
3666: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/
3667:
3668: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
3669: FROM
3670: (SELECT SUM(nvl(pria.quantity,0)) req_qty

Line 3671: FROM po_requisitions_interface_all pria

3667:
3668: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
3669: FROM
3670: (SELECT SUM(nvl(pria.quantity,0)) req_qty
3671: FROM po_requisitions_interface_all pria
3672: WHERE pria.wip_entity_id = l_eam_mat_req_rec.wip_entity_id
3673: AND pria.destination_organization_id = l_eam_mat_req_rec.organization_id
3674: AND pria.wip_operation_seq_num = l_eam_mat_req_rec.operation_seq_num
3675: AND pria.item_id = l_eam_mat_req_rec.inventory_item_id

Line 4521: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/

4517: --13102446 trigger requisition again for the cancelled quantity where the earlier Req/PO was cancelled
4518:
4519: BEGIN
4520:
4521: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/
4522:
4523: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
4524: FROM
4525: (SELECT SUM(nvl(pria.quantity,0)) req_qty

Line 4526: FROM po_requisitions_interface_all pria

4522:
4523: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
4524: FROM
4525: (SELECT SUM(nvl(pria.quantity,0)) req_qty
4526: FROM po_requisitions_interface_all pria
4527: WHERE pria.wip_entity_id =l_eam_direct_items_rec.wip_entity_id
4528: AND pria.destination_organization_id = l_eam_direct_items_rec.organization_id
4529: AND pria.wip_operation_seq_num = l_eam_direct_items_rec.operation_seq_num
4530: AND pria.item_id is null

Line 4578: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/

4574:
4575: ELSE -- Don't trigger requisition again for the cancelled quantity where the earlier Req/PO was cancelled
4576:
4577: BEGIN
4578: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/
4579: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
4580: FROM
4581: (SELECT SUM(nvl(pria.quantity,0)) req_qty
4582: FROM po_requisitions_interface_all pria

Line 4582: FROM po_requisitions_interface_all pria

4578: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/
4579: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
4580: FROM
4581: (SELECT SUM(nvl(pria.quantity,0)) req_qty
4582: FROM po_requisitions_interface_all pria
4583: WHERE pria.wip_entity_id =l_eam_direct_items_rec.wip_entity_id
4584: AND pria.destination_organization_id = l_eam_direct_items_rec.organization_id
4585: AND pria.wip_operation_seq_num = l_eam_direct_items_rec.operation_seq_num
4586: AND pria.item_id is null