APPS.MSC_CL_EAM_ODS_LOAD dependencies on MSC_SUPPLIES

Line 961: lv_tbl:= 'MSC_SUPPLIES';

957: -- ========= Prepare the Cursor Statement ==========
958: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
959: lv_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
960: ELSE
961: lv_tbl:= 'MSC_SUPPLIES';
962: END IF;
963:
964: IF (MSC_CL_COLLECTION.v_is_complete_refresh
965: OR MSC_CL_COLLECTION.v_is_partial_refresh)

Line 997: ||' MSC_SUPPLIES_S.NEXTVAL,'

993: ||' CREATION_DATE, '
994: ||' CREATED_BY) '
995: ||'SELECT'
996: ||' -1,'
997: ||' MSC_SUPPLIES_S.NEXTVAL,'
998: ||' t1.INVENTORY_ITEM_ID,'
999: ||' ms.ORGANIZATION_ID,'
1000: ||' ''AGGR-'''||'||MSC_SUPPLIES_AGGR_WO_S.NEXTVAL,'
1001: ||' ms.NEW_ORDER_QUANTITY,'

Line 1000: ||' ''AGGR-'''||'||MSC_SUPPLIES_AGGR_WO_S.NEXTVAL,'

996: ||' -1,'
997: ||' MSC_SUPPLIES_S.NEXTVAL,'
998: ||' t1.INVENTORY_ITEM_ID,'
999: ||' ms.ORGANIZATION_ID,'
1000: ||' ''AGGR-'''||'||MSC_SUPPLIES_AGGR_WO_S.NEXTVAL,'
1001: ||' ms.NEW_ORDER_QUANTITY,'
1002: ||' ms.NEW_SCHEDULE_DATE,'
1003: ||' ms.FIRM_PLANNED_TYPE,'
1004: ||' ms.NEW_WIP_START_DATE,'

Line 1058: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');

1054: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
1055: '========================================');
1056: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1057: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_FORECASTS');
1058: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
1059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1060: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1061: RAISE;
1062: ELSE

Line 1067: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');

1063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
1064: '========================================');
1065: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1066: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_FORECASTS');
1067: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
1068: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1070: END IF;
1071: END;

Line 1106: lv_supplies_tbl:= 'MSC_SUPPLIES';

1102: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
1103: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1104: ELSE
1105: lv_tbl:= 'MSC_DEMANDS';
1106: lv_supplies_tbl:= 'MSC_SUPPLIES';
1107: END IF;
1108:
1109:
1110: lv_cursor_stmt:=

Line 1231: lv_supplies_tbl:= 'MSC_SUPPLIES';

1227: lv_tbl:= 'RESOURCE_REQUIREMENTS_'||MSC_CL_COLLECTION.v_instance_code;
1228: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1229: ELSE
1230: lv_tbl:= 'MSC_RESOURCE_REQUIREMENTS';
1231: lv_supplies_tbl:= 'MSC_SUPPLIES';
1232: END IF;
1233:
1234:
1235: lv_cursor_stmt:=

Line 1783: from msc_supplies s,

1779:
1780: cursor c_prod_stock is
1781: select s.inventory_item_id,s.asset_item_id,s.order_type,s.order_number,
1782: s.transaction_id,s.organization_id,s.activity_item_id
1783: from msc_supplies s,
1784: msc_eam_act_associations mea
1785: where s.asset_item_id = mea.asset_rebuild_item_id
1786: and s.inventory_item_id = mea.asset_rebuild_item_id
1787: and s.activity_item_id = mea.asset_activity_id

Line 1803: update msc_supplies ms

1799:
1800: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Updation of Produces_to_stock flag' );
1801:
1802: for c_rec in c_prod_stock loop
1803: update msc_supplies ms
1804: set ms.produces_to_stock =1
1805: where ms.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
1806: and ms.plan_id=-1
1807: and ms.order_type= c_rec.order_type