DBA Data[Home] [Help]

APPS.ZX_SRVC_TYP_PKG dependencies on AP_SUPPLIERS

Line 5123: SHIP/BILL FROM N SHIP_THIRD_PTY_ACCT_ID Via AP_SUPPLIERS

5119: SHIP/BILL TO N NULL (PTP is always expected)
5120:
5121: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
5122:
5123: SHIP/BILL FROM N SHIP_THIRD_PTY_ACCT_ID Via AP_SUPPLIERS
5124: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of VENDOR_ID.
5125:
5126: */
5127: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5162: FROM ap_suppliers po

5158: SELECT po.vendor_name,
5159: hp.party_number
5160: INTO l_ptnr_loc_tbl.ship_from_party_name(p_ptnr_idx),
5161: l_ptnr_loc_tbl.ship_from_party_number(p_ptnr_idx)
5162: FROM ap_suppliers po
5163: , hz_parties hp
5164: WHERE po.vendor_id = l_ship_third_pty_acct_id
5165: AND po.party_id = hp.party_id;
5166: EXCEPTION WHEN OTHERS THEN

Line 5212: FROM ap_suppliers po

5208: SELECT po.vendor_name,
5209: hp.party_number
5210: INTO l_ptnr_loc_tbl.bill_from_party_name(p_ptnr_idx),
5211: l_ptnr_loc_tbl.bill_from_party_number(p_ptnr_idx)
5212: FROM ap_suppliers po
5213: , hz_parties hp
5214: WHERE po.vendor_id = l_bill_third_pty_acct_id
5215: AND po.party_id = hp.party_id;
5216: EXCEPTION WHEN OTHERS THEN