APPS.CSI_ORDER_SHIP_PUB dependencies on HZ_CUST_ACCOUNTS

Line 434: FROM hz_cust_accounts

430: l_c_tpd_tbl(1).txn_party_detail_id := fnd_api.g_miss_num;
431:
432: SELECT party_id
433: INTO l_c_tpd_tbl(1).party_source_id
434: FROM hz_cust_accounts
435: WHERE cust_account_id = p_order_line_rec.customer_id;
436:
437: l_c_tpd_tbl(1).party_source_table := 'HZ_PARTIES';
438: l_c_tpd_tbl(1).relationship_type_code := 'OWNER';

Line 2028: /* Derive the party_id from hz_cust_accounts table */

2024: mmt_rec.ib_current_loc_id := mmt_rec.ship_to_org_id;
2025: END IF;
2026:
2027:
2028: /* Derive the party_id from hz_cust_accounts table */
2029:
2030: csi_utl_pkg.get_party_id(
2031: p_cust_acct_id => mmt_rec.end_customer_id, --mmt_rec.sold_to_org_id,
2032: x_party_id => l_party_id,

Line 4334: FROM hz_cust_accounts

4330: -- build owner party
4331:
4332: SELECT party_id
4333: INTO l_owner_party_id
4334: FROM hz_cust_accounts
4335: WHERE cust_account_id = l_order_line_rec.sold_to_org_id;
4336:
4337: SELECT instance_party_id,
4338: object_version_number