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 489: hz_cust_accounts cust_acct, -- Added for Bug# 4579790

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

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

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

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

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

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

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