APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_ST_ITEM_CUSTOMERS

Line 891: from msc_st_item_customers mic

887: customer_id,
888: customer_site_id,
889: customer_item_name,
890: count(*) count
891: from msc_st_item_customers mic
892: where sr_instance_id = p_instance_id
893: and item_name is not null
894: group by customer_id,
895: customer_site_id,

Line 1063: /* Error out records in msc_st_item_customers if

1059: END IF;
1060:
1061: LOG_MESSAGE('Validation of msc_item_suppliers finished successfully');
1062:
1063: /* Error out records in msc_st_item_customers if
1064: same Customer Item belonging to same Customer Site is pointing
1065: to multiple master items.
1066: */
1067:

Line 1106: UPDATE msc_st_item_customers msic

1102:
1103: END LOOP;
1104:
1105: FORALL i IN 1..a_company_id.COUNT
1106: UPDATE msc_st_item_customers msic
1107: set process_flag = MSC_CL_COLLECTION.G_ERROR
1108: where msic.customer_id = a_customer_id(i)
1109: and nvl(msic.customer_site_id, -99) = nvl(a_customer_site_id (i), -99)
1110: and msic.customer_item_name = a1_item_name(i);

Line 1232: from msc_st_item_customers msic,

1228: CURSOR custItemCompanies IS
1229: select ROWIDTOCHAR(msic.rowid),
1230: mcil.company_id,
1231: -99
1232: from msc_st_item_customers msic,
1233: msc_company_id_lid mcil
1234: where msic.customer_id = mcil.sr_company_id
1235: and msic.sr_instance_id = mcil.sr_instance_id
1236: and mcil.partner_type = G_CUSTOMER

Line 1244: from msc_st_item_customers msic,

1240: UNION
1241: select ROWIDTOCHAR(msic.rowid),
1242: mcil.company_id,
1243: mcsil.company_site_id
1244: from msc_st_item_customers msic,
1245: msc_company_id_lid mcil,
1246: msc_company_site_id_lid mcsil
1247: where msic.customer_id = mcil.sr_company_id
1248: and msic.sr_instance_id = mcil.sr_instance_id

Line 1303: UPDATE msc_st_item_customers msic

1299:
1300: IF a_rowid.COUNT > 0 THEN
1301: BEGIN
1302: FORALL i IN 1..a_rowid.COUNT
1303: UPDATE msc_st_item_customers msic
1304: set company_id = a_company_id(i),
1305: company_site_id = decode(a_company_site_id(i), -99, null, a_company_site_id(i))
1306: where msic.rowid = CHARTOROWID(a_rowid(i));
1307: EXCEPTION WHEN OTHERS THEN

Line 1860: from msc_st_item_customers mic,

1856: mic.uom_code,
1857: mic.list_price,
1858: mic.planner_code,
1859: mic.refresh_number
1860: from msc_st_item_customers mic,
1861: msc_tp_id_lid mtil,
1862: msc_tp_site_id_lid mtsil,
1863: msc_item_id_lid t1
1864: where t1.SR_INVENTORY_ITEM_ID = mic.inventory_item_id