eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_CONSOLIDATION_PUB dependencies on HZ_CUST_ACCOUNTS

Line 484: hz_cust_accounts cust_acct, -- Added for Bug# 4579790

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
488: --wdd.customer_id = c.customer_id -- Commented for Bug# 4579790

Line 519: hz_cust_accounts cust_acct -- Added for Bug# 4579790

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
523: AND wdd.organization_id = p_org_id

Line 548: hz_cust_accounts cust_acct, -- Added for Bug# 4579790

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
552: --wdd.customer_id = c.customer_id -- Commented for Bug# 4579790

Line 583: hz_cust_accounts cust_acct -- Added for Bug# 4579790

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
587: AND wdd.organization_id = p_org_id