APPS.MSC_CL_ITEM_PULL dependencies on MSC_ST_SYSTEM_ITEMS

Line 330: MSC_CL_PULL.v_table_name:= 'MSC_ST_SYSTEM_ITEMS';

326: ELSE
327: RETURN;
328: END IF;
329: end if; -- For Huge Number of Org
330: MSC_CL_PULL.v_table_name:= 'MSC_ST_SYSTEM_ITEMS';
331:
332: if (MSC_CL_PULL.G_COLLECT_ITEM_COSTS = 'N') and (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) then
333: MSC_CL_PULL.v_view_name := 'MRP_AP_NOCOST_SYSTEM_ITEMS_V';
334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : View name = ' || MSC_CL_PULL.v_view_name);

Line 560: 'insert into MSC_ST_SYSTEM_ITEMS'

556:
557:
558:
559: v_sql_stmt:=
560: 'insert into MSC_ST_SYSTEM_ITEMS'
561: ||' ( ORGANIZATION_ID,'
562: ||' SR_INVENTORY_ITEM_ID,'
563: ||' LOTS_EXPIRATION,'
564: ||' LOT_CONTROL_CODE,'

Line 1558: DELETE from MSC_ST_SYSTEM_ITEMS st_item

1554: lv_item_name VARCHAR2(255);
1555: lv_ins_stmt VARCHAR2(32767);
1556: BEGIN
1557:
1558: DELETE from MSC_ST_SYSTEM_ITEMS st_item
1559: where st_item.SR_INVENTORY_ITEM_ID in ( -1000,-1001,-1002,-1003,-1004) and
1560: st_item.sr_instance_id = MSC_CL_PULL.v_instance_id and
1561: st_item.organization_id in
1562: ( select x.organization_id

Line 1571: insert into MSC_ST_SYSTEM_ITEMS (

1567: );
1568: commit;
1569:
1570: lv_item_name := NVL(FND_PROFILE.VALUE('MSC_EAM_NO_ACTIVITY_ITEM'),'No Activity Item');
1571: insert into MSC_ST_SYSTEM_ITEMS (
1572: ORGANIZATION_ID,
1573: SR_INVENTORY_ITEM_ID,
1574: SR_INSTANCE_ID,
1575: LOT_CONTROL_CODE,

Line 1628: insert into MSC_ST_SYSTEM_ITEMS (

1624: commit;
1625:
1626: lv_item_name := NVL(FND_PROFILE.VALUE('MSC_WIP_NONSTD_JOB_ITEM'),'Non Standard Job Item');
1627:
1628: insert into MSC_ST_SYSTEM_ITEMS (
1629: ORGANIZATION_ID,
1630: SR_INVENTORY_ITEM_ID,
1631: SR_INSTANCE_ID,
1632: LOT_CONTROL_CODE,

Line 1682: lv_ins_stmt := ' insert into MSC_ST_SYSTEM_ITEMS ( '

1678:
1679: commit;
1680:
1681: /*inserting dummy items for aggregation */
1682: lv_ins_stmt := ' insert into MSC_ST_SYSTEM_ITEMS ( '
1683: ||' ORGANIZATION_ID, '
1684: ||' SR_INVENTORY_ITEM_ID, '
1685: ||' SR_INSTANCE_ID, '
1686: ||' LOT_CONTROL_CODE, '

Line 1738: lv_ins_stmt := ' insert into MSC_ST_SYSTEM_ITEMS ( '

1734:
1735: EXECUTE IMMEDIATE lv_ins_stmt USING MSC_CL_PULL.V_ICODE;
1736: commit;
1737:
1738: lv_ins_stmt := ' insert into MSC_ST_SYSTEM_ITEMS ( '
1739: ||' ORGANIZATION_ID, '
1740: ||' SR_INVENTORY_ITEM_ID, '
1741: ||' SR_INSTANCE_ID, '
1742: ||' LOT_CONTROL_CODE, '

Line 1793: lv_ins_stmt := ' insert into MSC_ST_SYSTEM_ITEMS ( '

1789: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||lv_ins_stmt);
1790: EXECUTE IMMEDIATE lv_ins_stmt USING MSC_CL_PULL.V_ICODE;
1791: commit;
1792:
1793: lv_ins_stmt := ' insert into MSC_ST_SYSTEM_ITEMS ( '
1794: ||' ORGANIZATION_ID, '
1795: ||' SR_INVENTORY_ITEM_ID, '
1796: ||' SR_INSTANCE_ID, '
1797: ||' LOT_CONTROL_CODE, '