APPS.MSC_SATP_FUNC dependencies on WSH_CARRIER_SERVICES

Line 3890: WSH_CARRIER_SERVICES wcs,

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(+)
3894: AND wca.CARRIER_ID = wcs1.CARRIER_ID(+)

Line 3891: WSH_CARRIER_SERVICES wcs1

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(+)
3894: AND wca.CARRIER_ID = wcs1.CARRIER_ID(+)
3895: AND wca.ENABLED_FLAG = 'Y'

Line 3933: WSH_CARRIER_SERVICES wcs,

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(+)
3937: AND wca.CARRIER_ID = wcs1.CARRIER_ID(+)

Line 3934: WSH_CARRIER_SERVICES wcs1

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(+)
3937: AND wca.CARRIER_ID = wcs1.CARRIER_ID(+)
3938: AND wca.ENABLED_FLAG = 'Y'

Line 3972: WSH_CARRIER_SERVICES wcs

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'
3976: AND wca.ENABLED_FLAG = 'Y'