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.MSC_SATP_FUNC dependencies on WSH_CALENDAR_ASSIGNMENTS

Line 3889: WSH_CALENDAR_ASSIGNMENTS wca,

3885: SELECT calendar_code
3886: INTO l_calendar_code
3887: FROM (SELECT wca.CALENDAR_CODE
3888: FROM WSH_CARRIERS wc,
3889: WSH_CALENDAR_ASSIGNMENTS wca,
3890: WSH_CARRIER_SERVICES wcs,
3891: WSH_CARRIER_SERVICES wcs1
3892: WHERE wc.FREIGHT_CODE(+) = wca.FREIGHT_CODE
3893: AND wc.CARRIER_ID = wcs.CARRIER_ID(+)

Line 3932: WSH_CALENDAR_ASSIGNMENTS wca,

3928: SELECT calendar_code
3929: INTO l_calendar_code
3930: FROM (SELECT wca.CALENDAR_CODE
3931: FROM WSH_CARRIERS wc,
3932: WSH_CALENDAR_ASSIGNMENTS wca,
3933: WSH_CARRIER_SERVICES wcs,
3934: WSH_CARRIER_SERVICES wcs1
3935: WHERE wc.FREIGHT_CODE(+) = wca.FREIGHT_CODE
3936: AND wc.CARRIER_ID = wcs.CARRIER_ID(+)

Line 3971: FROM WSH_CALENDAR_ASSIGNMENTS wca,

3967: -- l_calendar_code is already initialized to FOC
3968:
3969: SELECT wca.CALENDAR_CODE
3970: INTO l_calendar_code
3971: FROM WSH_CALENDAR_ASSIGNMENTS wca,
3972: WSH_CARRIER_SERVICES wcs
3973: WHERE wca.CARRIER_ID = wcs.CARRIER_ID
3974: AND wca.CALENDAR_TYPE = 'CARRIER'
3975: AND wca.ASSOCIATION_TYPE = 'CARRIER'