APPS.WMS_CONSOLIDATION_PUB dependencies on HZ_PARTIES

Line 483: hz_parties party, -- Added for Bug# 4579790

479: FROM
480: wsh_delivery_details wdd,
481: wsh_delivery_assignments_v wda,
482: -- ra_customers c, -- Commented for Bug# 4579790
483: hz_parties party, -- Added for Bug# 4579790
484: hz_cust_accounts cust_acct, -- Added for Bug# 4579790
485: wms_license_plate_numbers wlpn,
486: wsh_delivery_details wdd2
487: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790

Line 518: hz_parties party, -- Added for Bug# 4579790

514: FROM
515: wsh_delivery_details wdd,
516: wsh_delivery_assignments_v wda,
517: -- ra_customers c, -- Commented for Bug# 4579790
518: hz_parties party, -- Added for Bug# 4579790
519: hz_cust_accounts cust_acct -- Added for Bug# 4579790
520: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790
521: --wdd.customer_id = c.customer_id -- Commented for Bug# 4579790
522: AND cust_acct.party_id = party.party_id -- Added for Bug# 4579790

Line 547: hz_parties party, -- Added for Bug# 4579790

543: FROM
544: wsh_delivery_details wdd,
545: wsh_delivery_assignments_v wda,
546: -- ra_customers c, -- Commented for Bug# 4579790
547: hz_parties party, -- Added for Bug# 4579790
548: hz_cust_accounts cust_acct, -- Added for Bug# 4579790
549: wms_license_plate_numbers wlpn,
550: wsh_delivery_details wdd2
551: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790

Line 582: hz_parties party, -- Added for Bug# 4579790

578: FROM
579: wsh_delivery_details_ob_grp_v wdd,
580: wsh_delivery_assignments_v wda,
581: -- ra_customers c, -- Commented for Bug# 4579790
582: hz_parties party, -- Added for Bug# 4579790
583: hz_cust_accounts cust_acct -- Added for Bug# 4579790
584: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790
585: --wdd.customer_id = c.customer_id -- Commented for Bug# 4579790
586: AND cust_acct.party_id = party.party_id -- Added for Bug# 4579790