DBA Data[Home] [Help]

APPS.ZX_SRVC_TYP_PKG dependencies on AP_SUPPLIERS

Line 5950: SHIP/BILL FROM N SHIP_THIRD_PTY_ACCT_ID Via AP_SUPPLIERS

5946: SHIP/BILL TO N NULL (PTP is always expected)
5947:
5948: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5949:
5950: SHIP/BILL FROM N SHIP_THIRD_PTY_ACCT_ID Via AP_SUPPLIERS
5951: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of VENDOR_ID.
5952:
5953: */
5954: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5989: FROM ap_suppliers po

5985: SELECT po.vendor_name,
5986: hp.party_number
5987: INTO l_ptnr_loc_tbl.ship_from_party_name(p_ptnr_idx),
5988: l_ptnr_loc_tbl.ship_from_party_number(p_ptnr_idx)
5989: FROM ap_suppliers po
5990: , hz_parties hp
5991: WHERE po.vendor_id = l_ship_third_pty_acct_id
5992: AND po.party_id = hp.party_id;
5993: EXCEPTION WHEN OTHERS THEN

Line 6039: FROM ap_suppliers po

6035: SELECT po.vendor_name,
6036: hp.party_number
6037: INTO l_ptnr_loc_tbl.bill_from_party_name(p_ptnr_idx),
6038: l_ptnr_loc_tbl.bill_from_party_number(p_ptnr_idx)
6039: FROM ap_suppliers po
6040: , hz_parties hp
6041: WHERE po.vendor_id = l_bill_third_pty_acct_id
6042: AND po.party_id = hp.party_id;
6043: EXCEPTION WHEN OTHERS THEN