APPS.PO_SUPPLY dependencies on PO_RELEASES_ALL

Line 618: FROM po_releases_all por

614: /*Bug 4537860:Hit the _all tables instead of the striped views.*/
615: CURSOR auth_status(release_id NUMBER)
616: IS
617: SELECT por.authorization_status
618: FROM po_releases_all por
619: WHERE por.po_release_id = release_id;
620:
621: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.approve_blanket_supply';
622: d_progress NUMBER;

Line 738: FROM po_releases_all por

734: /*Bug 4537860:Hit the _all tables instead of the striped views.*/
735: CURSOR auth_status(release_id NUMBER)
736: IS
737: SELECT por.authorization_status, por.po_header_id
738: FROM po_releases_all por
739: WHERE por.po_release_id = release_id;
740:
741: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.approve_planned_supply';
742: d_progress NUMBER;

Line 1056: , po_releases_all por

1052: SELECT NVL(SUM(pod.quantity_ordered - NVL(pod.quantity_delivered, 0)
1053: - NVL(pod.quantity_cancelled, 0)), 0)
1054: INTO l_released_qty
1055: FROM po_distributions_all pod
1056: , po_releases_all por
1057: WHERE pod.source_distribution_id = l_distid
1058: AND pod.po_release_id = por.po_release_id
1059: AND NVL(por.authorization_status, 'IN PROCESS') = 'APPROVED';
1060:

Line 1608: FROM po_releases_all por

1604:
1605: CURSOR rel(release_id NUMBER)
1606: IS
1607: SELECT por.po_header_id
1608: FROM po_releases_all por
1609: WHERE por.po_release_id = release_id;
1610:
1611: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.cancel_planned';
1612: d_progress NUMBER;