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.WSH_WSHRDPAK_XMLP_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 598: HZ_CUST_ACCT_SITES_ALL CA,

594: PS.LOCATION_ID
595: INTO BILL_TO_LOC_ID
596: FROM
597: HZ_PARTY_SITES PS,
598: HZ_CUST_ACCT_SITES_ALL CA,
599: HZ_CUST_SITE_USES_ALL SU,
600: OE_ORDER_LINES_ALL OLA
601: WHERE OLA.LINE_ID = CF_OE_LINE_ID
602: AND SU.SITE_USE_ID = OLA.INVOICE_TO_ORG_ID

Line 838: HZ_CUST_ACCT_SITES_ALL CA,

834: ,HP.PERSON_TITLE) TITLE
835: INTO BILL_TO_CUST_NAME,L_PERSON_TITLE
836: FROM
837: HZ_PARTY_SITES PS,
838: HZ_CUST_ACCT_SITES_ALL CA,
839: HZ_CUST_SITE_USES_ALL SU,
840: HZ_PARTIES HP,
841: OE_ORDER_LINES_ALL OLA
842: WHERE OLA.LINE_ID = F_OE_LINE_ID

Line 983: HZ_CUST_ACCT_SITES_ALL CA,

979: ,HP.PERSON_TITLE) TITLE
980: INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE
981: FROM
982: HZ_PARTY_SITES PS,
983: HZ_CUST_ACCT_SITES_ALL CA,
984: HZ_CUST_SITE_USES_ALL SU,
985: HZ_PARTIES HP
986: WHERE SU.SITE_USE_ID = SHP_TO_SITE_USE_ID --RTV changes
987: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID

Line 1091: HZ_CUST_ACCT_SITES_ALL CA,

1087: PS.LOCATION_ID
1088: INTO BILL_TO_LOC_ID
1089: FROM
1090: HZ_PARTY_SITES PS,
1091: HZ_CUST_ACCT_SITES_ALL CA,
1092: HZ_CUST_SITE_USES_ALL SU,
1093: OE_ORDER_LINES_ALL OLA
1094: WHERE OLA.LINE_ID = F_OE_LINE_ID
1095: AND SU.SITE_USE_ID = OLA.INVOICE_TO_ORG_ID