DBA Data[Home] [Help]

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 1969: /* Derive the party_id from hz_cust_accounts table */

1965: mmt_rec.ib_current_loc_id := mmt_rec.ship_to_org_id;
1966: END IF;
1967:
1968:
1969: /* Derive the party_id from hz_cust_accounts table */
1970:
1971: csi_utl_pkg.get_party_id(
1972: p_cust_acct_id => mmt_rec.end_customer_id, --mmt_rec.sold_to_org_id,
1973: x_party_id => l_party_id,

Line 4255: FROM hz_cust_accounts

4251: -- build owner party
4252:
4253: SELECT party_id
4254: INTO l_owner_party_id
4255: FROM hz_cust_accounts
4256: WHERE cust_account_id = l_order_line_rec.sold_to_org_id;
4257:
4258: SELECT instance_party_id,
4259: object_version_number