APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_ST_ITEM_CUSTOMERS

Line 974: from msc_st_item_customers mic

970: customer_id,
971: customer_site_id,
972: customer_item_name,
973: count(*) count
974: from msc_st_item_customers mic
975: where sr_instance_id = p_instance_id
976: and item_name is not null
977: group by customer_id,
978: customer_site_id,

Line 1146: /* Error out records in msc_st_item_customers if

1142: END IF;
1143:
1144: LOG_MESSAGE('Validation of msc_item_suppliers finished successfully');
1145:
1146: /* Error out records in msc_st_item_customers if
1147: same Customer Item belonging to same Customer Site is pointing
1148: to multiple master items.
1149: */
1150:

Line 1189: UPDATE msc_st_item_customers msic

1185:
1186: END LOOP;
1187:
1188: FORALL i IN 1..a_company_id.COUNT
1189: UPDATE msc_st_item_customers msic
1190: set process_flag = MSC_CL_COLLECTION.G_ERROR
1191: where msic.customer_id = a_customer_id(i)
1192: and nvl(msic.customer_site_id, -99) = nvl(a_customer_site_id (i), -99)
1193: and msic.customer_item_name = a1_item_name(i);

Line 1315: from msc_st_item_customers msic,

1311: CURSOR custItemCompanies IS
1312: select ROWIDTOCHAR(msic.rowid),
1313: mcil.company_id,
1314: -99
1315: from msc_st_item_customers msic,
1316: msc_company_id_lid mcil
1317: where msic.customer_id = mcil.sr_company_id
1318: and msic.sr_instance_id = mcil.sr_instance_id
1319: and mcil.partner_type = G_CUSTOMER

Line 1327: from msc_st_item_customers msic,

1323: UNION
1324: select ROWIDTOCHAR(msic.rowid),
1325: mcil.company_id,
1326: mcsil.company_site_id
1327: from msc_st_item_customers msic,
1328: msc_company_id_lid mcil,
1329: msc_company_site_id_lid mcsil
1330: where msic.customer_id = mcil.sr_company_id
1331: and msic.sr_instance_id = mcil.sr_instance_id

Line 1386: UPDATE msc_st_item_customers msic

1382:
1383: IF a_rowid.COUNT > 0 THEN
1384: BEGIN
1385: FORALL i IN 1..a_rowid.COUNT
1386: UPDATE msc_st_item_customers msic
1387: set company_id = a_company_id(i),
1388: company_site_id = decode(a_company_site_id(i), -99, null, a_company_site_id(i))
1389: where msic.rowid = CHARTOROWID(a_rowid(i));
1390: EXCEPTION WHEN OTHERS THEN

Line 1943: from msc_st_item_customers mic,

1939: mic.uom_code,
1940: mic.list_price,
1941: mic.planner_code,
1942: mic.refresh_number
1943: from msc_st_item_customers mic,
1944: msc_tp_id_lid mtil,
1945: msc_tp_site_id_lid mtsil,
1946: msc_item_id_lid t1
1947: where t1.SR_INVENTORY_ITEM_ID = mic.inventory_item_id