APPS.PO_SUPPLY dependencies on PO_RELEASES

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 730: l_auth_status po_releases.authorization_status%TYPE;

726: FUNCTION approve_planned_supply(p_docid IN NUMBER)
727: RETURN BOOLEAN
728: IS
729:
730: l_auth_status po_releases.authorization_status%TYPE;
731: l_po_header_id po_releases.po_header_id%TYPE;
732:
733: l_supply_flag BOOLEAN;
734: /*Bug 4537860:Hit the _all tables instead of the striped views.*/

Line 731: l_po_header_id po_releases.po_header_id%TYPE;

727: RETURN BOOLEAN
728: IS
729:
730: l_auth_status po_releases.authorization_status%TYPE;
731: l_po_header_id po_releases.po_header_id%TYPE;
732:
733: l_supply_flag BOOLEAN;
734: /*Bug 4537860:Hit the _all tables instead of the striped views.*/
735: CURSOR auth_status(release_id 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 1087: , po_releases_all por

1083: SELECT NVL(SUM(pod.quantity_ordered - NVL(pod.quantity_delivered, 0)
1084: - NVL(pod.quantity_cancelled, 0)), 0)
1085: INTO l_released_qty
1086: FROM po_distributions_all pod
1087: , po_releases_all por
1088: WHERE pod.source_distribution_id = l_distid
1089: AND pod.po_release_id = por.po_release_id
1090: AND NVL(por.authorization_status, 'IN PROCESS') = 'APPROVED';
1091:

Line 1715: l_headid po_releases.po_header_id%TYPE;

1711: IS
1712:
1713: l_supply_flag BOOLEAN := TRUE;
1714:
1715: l_headid po_releases.po_header_id%TYPE;
1716:
1717: /*Bug 4537860:Hit the _all tables instead of the striped views.*/
1718:
1719: CURSOR rel(release_id NUMBER)

Line 1722: FROM po_releases_all por

1718:
1719: CURSOR rel(release_id NUMBER)
1720: IS
1721: SELECT por.po_header_id
1722: FROM po_releases_all por
1723: WHERE por.po_release_id = release_id;
1724:
1725: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.cancel_planned';
1726: d_progress NUMBER;