APPS.MSC_X_UTIL dependencies on MSC_CALENDAR_ASSIGNMENTS

Line 1129: from msc_calendar_assignments ca,

1125: begin
1126: /* Get the Customer Receiving calendar */
1127: select nvl(ca1.CALENDAR_CODE, ca.CALENDAR_CODE)
1128: into lv_calendar_code
1129: from msc_calendar_assignments ca,
1130: msc_calendar_assignments ca1
1131: where ca.sr_instance_id = aps_sr_instance_id
1132: and ca.CALENDAR_TYPE = 'RECEIVING'
1133: and ca.partner_type = 2

Line 1130: msc_calendar_assignments ca1

1126: /* Get the Customer Receiving calendar */
1127: select nvl(ca1.CALENDAR_CODE, ca.CALENDAR_CODE)
1128: into lv_calendar_code
1129: from msc_calendar_assignments ca,
1130: msc_calendar_assignments ca1
1131: where ca.sr_instance_id = aps_sr_instance_id
1132: and ca.CALENDAR_TYPE = 'RECEIVING'
1133: and ca.partner_type = 2
1134: and ca.partner_id = aps_cust_partner_id

Line 1153: msc_calendar_assignments ca

1149: /* If there is no customer calendar, get the OEM Org Shipping or Mfg calendar */
1150: select nvl(ca.CALENDAR_CODE, tp.calendar_code)
1151: into lv_calendar_code
1152: from msc_trading_partners tp,
1153: msc_calendar_assignments ca
1154: where tp.sr_instance_id = aps_sr_instance_id
1155: and tp.sr_tp_id = aps_org_partner_id
1156: and tp.partner_type = 3
1157: and ca.sr_instance_id(+) = tp.sr_instance_id

Line 1193: from msc_calendar_assignments ca,

1189:
1190: /* Get the Org Receiving Calendar, if not available then get the OEM Orgs' Mfg calendar */
1191: select nvl(ca.CALENDAR_CODE, tp.calendar_code)
1192: into lv_calendar_code
1193: from msc_calendar_assignments ca,
1194: msc_trading_partners tp
1195: where tp.sr_instance_id = aps_sr_instance_id
1196: and tp.sr_tp_id = aps_org_partner_id
1197: and tp.partner_type = 3

Line 1215: from msc_calendar_assignments ca,

1211: select nvl(ca1.CALENDAR_CODE, ca.CALENDAR_CODE),
1212: nvl(ca1.sr_instance_id,ca.sr_instance_id)
1213: into lv_calendar_code,
1214: aps_sr_instance_id
1215: from msc_calendar_assignments ca,
1216: msc_calendar_assignments ca1
1217: where ca.CALENDAR_TYPE = 'RECEIVING'
1218: and ca.partner_type = 2
1219: and ca.partner_id = aps_cust_partner_id

Line 1216: msc_calendar_assignments ca1

1212: nvl(ca1.sr_instance_id,ca.sr_instance_id)
1213: into lv_calendar_code,
1214: aps_sr_instance_id
1215: from msc_calendar_assignments ca,
1216: msc_calendar_assignments ca1
1217: where ca.CALENDAR_TYPE = 'RECEIVING'
1218: and ca.partner_type = 2
1219: and ca.partner_id = aps_cust_partner_id
1220: and ca.ORGANIZATION_ID is null

Line 1241: from msc_calendar_assignments ca,

1237: begin
1238: /* Get the Customer or Customer Site Receiving calendar */
1239: select nvl(ca1.CALENDAR_CODE, ca.CALENDAR_CODE)
1240: into lv_calendar_code
1241: from msc_calendar_assignments ca,
1242: msc_calendar_assignments ca1
1243: where ca.sr_instance_id = aps_sr_instance_id
1244: and ca.CALENDAR_TYPE = 'RECEIVING'
1245: and ca.partner_type = 2

Line 1242: msc_calendar_assignments ca1

1238: /* Get the Customer or Customer Site Receiving calendar */
1239: select nvl(ca1.CALENDAR_CODE, ca.CALENDAR_CODE)
1240: into lv_calendar_code
1241: from msc_calendar_assignments ca,
1242: msc_calendar_assignments ca1
1243: where ca.sr_instance_id = aps_sr_instance_id
1244: and ca.CALENDAR_TYPE = 'RECEIVING'
1245: and ca.partner_type = 2
1246: and ca.partner_id = aps_cust_partner_id

Line 1264: msc_calendar_assignments ca

1260: /* If there is no customer calendar, get the OEM Org Shipping or Mfg calendar */
1261: select nvl(ca.CALENDAR_CODE, tp.calendar_code)
1262: into lv_calendar_code
1263: from msc_trading_partners tp,
1264: msc_calendar_assignments ca
1265: where tp.sr_instance_id = aps_sr_instance_id
1266: and tp.sr_tp_id = aps_org_partner_id
1267: and tp.partner_type = 3
1268: and ca.sr_instance_id(+) = tp.sr_instance_id