APPS.WMS_CONSOLIDATION_PUB dependencies on HZ_PARTIES

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

484: FROM
485: wsh_delivery_details wdd,
486: wsh_delivery_assignments_v wda,
487: -- ra_customers c, -- Commented for Bug# 4579790
488: hz_parties party, -- Added for Bug# 4579790
489: hz_cust_accounts cust_acct, -- Added for Bug# 4579790
490: wms_license_plate_numbers wlpn,
491: wsh_delivery_details wdd2
492: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790

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

519: FROM
520: wsh_delivery_details wdd,
521: wsh_delivery_assignments_v wda,
522: -- ra_customers c, -- Commented for Bug# 4579790
523: hz_parties party, -- Added for Bug# 4579790
524: hz_cust_accounts cust_acct -- Added for Bug# 4579790
525: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790
526: --wdd.customer_id = c.customer_id -- Commented for Bug# 4579790
527: AND cust_acct.party_id = party.party_id -- Added for Bug# 4579790

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

548: FROM
549: wsh_delivery_details wdd,
550: wsh_delivery_assignments_v wda,
551: -- ra_customers c, -- Commented for Bug# 4579790
552: hz_parties party, -- Added for Bug# 4579790
553: hz_cust_accounts cust_acct, -- Added for Bug# 4579790
554: wms_license_plate_numbers wlpn,
555: wsh_delivery_details wdd2
556: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790

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

583: FROM
584: wsh_delivery_details_ob_grp_v wdd,
585: wsh_delivery_assignments_v wda,
586: -- ra_customers c, -- Commented for Bug# 4579790
587: hz_parties party, -- Added for Bug# 4579790
588: hz_cust_accounts cust_acct -- Added for Bug# 4579790
589: WHERE wdd.customer_id = cust_acct.cust_account_id -- Added for Bug# 4579790
590: --wdd.customer_id = c.customer_id -- Commented for Bug# 4579790
591: AND cust_acct.party_id = party.party_id -- Added for Bug# 4579790