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_CALENDAR dependencies on MSC_CALENDAR_ASSIGNMENTS

Line 1018: FROM MSC_CALENDAR_ASSIGNMENTS

1014:
1015: SELECT calendar_code, association_type
1016: INTO l_calendar_code, p_association_type
1017: FROM (SELECT calendar_code, association_type
1018: FROM MSC_CALENDAR_ASSIGNMENTS
1019: WHERE SR_INSTANCE_ID = p_instance_id
1020: AND CALENDAR_TYPE in (l_calendar_type, 'CARRIER')
1021: AND PARTNER_TYPE = p_partner_type
1022: AND PARTNER_ID = p_partner_id

Line 1047: FROM MSC_CALENDAR_ASSIGNMENTS

1043:
1044: SELECT calendar_code, association_type
1045: INTO l_calendar_code, p_association_type
1046: FROM (SELECT calendar_code, association_type
1047: FROM MSC_CALENDAR_ASSIGNMENTS
1048: WHERE SR_INSTANCE_ID = p_instance_id
1049: AND CALENDAR_TYPE in (l_calendar_type, 'CARRIER')
1050: AND ORGANIZATION_ID = p_organization_id
1051: AND NVL(SHIP_METHOD_CODE, l_ship_method_code) = l_ship_method_code

Line 1076: FROM MSC_CALENDAR_ASSIGNMENTS

1072:
1073: -- p_partner_type = 4
1074: SELECT calendar_code, association_type
1075: INTO l_calendar_code, p_association_type
1076: FROM MSC_CALENDAR_ASSIGNMENTS
1077: WHERE SR_INSTANCE_ID = p_instance_id
1078: AND PARTNER_TYPE = p_partner_type
1079: AND SHIP_METHOD_CODE = l_ship_method_code;
1080:

Line 1208: FROM MSC_CALENDAR_ASSIGNMENTS

1204:
1205: SELECT calendar_code, association_type
1206: INTO l_calendar_code, p_association_type
1207: FROM (SELECT calendar_code, association_type
1208: FROM MSC_CALENDAR_ASSIGNMENTS
1209: WHERE SR_INSTANCE_ID = p_instance_id
1210: AND CALENDAR_TYPE in (l_calendar_type, 'CARRIER')
1211: AND PARTNER_TYPE = p_partner_type
1212: AND PARTNER_ID = p_partner_id

Line 1233: FROM MSC_CALENDAR_ASSIGNMENTS

1229: END IF;
1230: SELECT calendar_code, association_type
1231: INTO l_calendar_code, p_association_type
1232: FROM (SELECT calendar_code, association_type
1233: FROM MSC_CALENDAR_ASSIGNMENTS
1234: WHERE SR_INSTANCE_ID = p_instance_id
1235: AND CALENDAR_TYPE in (l_calendar_type, 'CARRIER')
1236: AND ORGANIZATION_ID = p_organization_id
1237: AND NVL(SHIP_METHOD_CODE, l_ship_method_code) = l_ship_method_code

Line 1256: FROM MSC_CALENDAR_ASSIGNMENTS

1252: -- l_calendar_code is already initialized to FOC
1253: -- p_partner_type = 4
1254: SELECT calendar_code, association_type
1255: INTO l_calendar_code, p_association_type
1256: FROM MSC_CALENDAR_ASSIGNMENTS
1257: WHERE SR_INSTANCE_ID = p_instance_id
1258: AND PARTNER_TYPE = p_partner_type
1259: AND SHIP_METHOD_CODE = l_ship_method_code;
1260: --END IF;