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_SITE_USES_ALL

Line 599: HZ_CUST_SITE_USES_ALL SU,

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
603: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID

Line 839: HZ_CUST_SITE_USES_ALL SU,

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
843: AND SU.SITE_USE_ID = OLA.INVOICE_TO_ORG_ID

Line 984: HZ_CUST_SITE_USES_ALL SU,

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
988: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID

Line 1092: HZ_CUST_SITE_USES_ALL SU,

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
1096: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID