APPS.POR_HISTORY_FEED_PKG dependencies on PO_RELEASES

Line 1065: TYPE tab_rel_num IS TABLE OF po_releases.release_num%TYPE;

1061:
1062: PROCEDURE Get_PO_Distributions IS
1063:
1064: TYPE tab_po_num IS TABLE OF po_headers.segment1%TYPE;
1065: TYPE tab_rel_num IS TABLE OF po_releases.release_num%TYPE;
1066: TYPE tab_po_header_id IS TABLE OF po_headers.po_header_id%TYPE;
1067: TYPE tab_po_release_id IS TABLE OF po_releases.po_release_id%TYPE;
1068: TYPE tab_cardno IS TABLE OF iby_creditcard.masked_cc_number%TYPE;
1069: TYPE tab_cardmember IS TABLE OF ap_cards.cardmember_name%TYPE;

Line 1067: TYPE tab_po_release_id IS TABLE OF po_releases.po_release_id%TYPE;

1063:
1064: TYPE tab_po_num IS TABLE OF po_headers.segment1%TYPE;
1065: TYPE tab_rel_num IS TABLE OF po_releases.release_num%TYPE;
1066: TYPE tab_po_header_id IS TABLE OF po_headers.po_header_id%TYPE;
1067: TYPE tab_po_release_id IS TABLE OF po_releases.po_release_id%TYPE;
1068: TYPE tab_cardno IS TABLE OF iby_creditcard.masked_cc_number%TYPE;
1069: TYPE tab_cardmember IS TABLE OF ap_cards.cardmember_name%TYPE;
1070: TYPE tab_card_type IS TABLE OF ap_card_programs.card_type_lookup_code%TYPE;
1071: TYPE tab_card_brand IS TABLE OF ap_card_programs.card_brand_lookup_code%TYPE;

Line 1323: PO_RELEASES PR,

1319: PLL.CANCEL_FLAG shipment_cancel_flag --ref
1320:
1321: FROM
1322: PO_HEADERS PH,
1323: PO_RELEASES PR,
1324: PO_LINES PL,
1325: PO_LINE_LOCATIONS PLL,
1326: PO_DISTRIBUTIONS PD,
1327: PO_VENDORS PV,

Line 1399: PO_RELEASES PR,

1395: PLL.CANCEL_FLAG shipment_cancel_flag --ref
1396:
1397: FROM
1398: PO_HEADERS PH,
1399: PO_RELEASES PR,
1400: PO_LINES PL,
1401: PO_LINE_LOCATIONS PLL,
1402: PO_DISTRIBUTIONS PD,
1403: PO_VENDORS PV,

Line 1531: PO_RELEASES PR,

1527:
1528: FROM
1529:
1530: PO_HEADERS PH,
1531: PO_RELEASES PR,
1532: PO_VENDORS PV,
1533: PO_VENDOR_SITES PVS,
1534: AP_CARDS AC,
1535: AP_CARD_PROGRAMS ACP,