eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_SUPPLY_ODS_LOAD dependencies on MSC_SUPPLIES

Line 531: lv_tbl:= 'MSC_SUPPLIES';

527:
528: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
529: lv_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
530: ELSE
531: lv_tbl:= 'MSC_SUPPLIES';
532: END IF;
533:
534: lv_sql_stmt:=
535: 'INSERT INTO '||lv_tbl

Line 678: ||' MSC_SUPPLIES_S.NEXTVAL,'

674: ||' ACTIVITY_ITEM_ID'
675: ||' )'
676: ||'VALUES'
677: ||'( -1,'
678: ||' MSC_SUPPLIES_S.NEXTVAL,'
679: ||' :INVENTORY_ITEM_ID,'
680: ||' :ORGANIZATION_ID,'
681: ||' :FROM_ORGANIZATION_ID,'
682: ||' :SR_INSTANCE_ID,'

Line 824: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);

820: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply');
821:
822: IF MSC_CL_COLLECTION.v_is_complete_refresh AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
823:
824: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
825:
826: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
827: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
828: ELSE

Line 827: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);

823:
824: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
825:
826: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
827: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
828: ELSE
829: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
830: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
831: END IF;

Line 830: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);

826: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
827: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
828: ELSE
829: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
830: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
831: END IF;
832:
833: END IF;
834:

Line 845: /*UPDATE MSC_SUPPLIES

841: refresh.
842: In order to keep the transaction_id, set the quantitiy to zero
843: for delete. */
844:
845: /*UPDATE MSC_SUPPLIES
846: SET NEW_ORDER_QUANTITY= 0.0,
847: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
848: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
849: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 855: lv_sql_stmt1 := ' UPDATE MSC_SUPPLIES '

851: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
852: AND ORDER_TYPE= 11
853: AND SR_MTL_SUPPLY_ID= -1;*/
854:
855: lv_sql_stmt1 := ' UPDATE MSC_SUPPLIES '
856: ||' SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE, '
857: ||' OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY, '
858: ||' NEW_ORDER_QUANTITY= 0.0, '
859: ||' REFRESH_NUMBER= :v_last_collection_id, '

Line 894: UPDATE MSC_SUPPLIES ms

890:
891: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd PO-0');
892:
893:
894: UPDATE MSC_SUPPLIES ms
895: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
896: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
897: NEW_ORDER_QUANTITY= 0.0,
898: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

Line 916: UPDATE MSC_SUPPLIES ms

912: if c_rec.ORDER_TYPE = 70 then
913: MSC_CL_COLLECTION.link_top_transaction_id_req := TRUE;
914: end if;
915:
916: UPDATE MSC_SUPPLIES ms
917: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
918: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
919: NEW_ORDER_QUANTITY= 0.0,
920: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

Line 937: UPDATE MSC_SUPPLIES ms

933:
934: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP DSC JOB-0');
935:
936:
937: UPDATE MSC_SUPPLIES ms
938: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
939: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
940: NEW_ORDER_QUANTITY= 0.0,
941: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

Line 958: UPDATE MSC_SUPPLIES

954:
955: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP REPT ITEM-0');
956:
957:
958: UPDATE MSC_SUPPLIES
959: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
960: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
961: OLD_DAILY_RATE = DAILY_RATE,
962: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,

Line 982: UPDATE MSC_SUPPLIES

978:
979: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd OH-0');
980:
981:
982: UPDATE MSC_SUPPLIES
983: --SET NEW_ORDER_QUANTITY= 0.0,
984: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
985: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
986: NEW_ORDER_QUANTITY= NEW_ORDER_QUANTITY-c_rec.NEW_ORDER_QUANTITY, /*Bug: 2791310 */

Line 1013: UPDATE MSC_SUPPLIES

1009:
1010:
1011:
1012:
1013: UPDATE MSC_SUPPLIES
1014: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
1015: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
1016: NEW_ORDER_QUANTITY= 0.0,
1017: DAILY_RATE= 0.0,

Line 1034: UPDATE MSC_SUPPLIES

1030:
1031: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd USUP-0');
1032:
1033:
1034: UPDATE MSC_SUPPLIES
1035: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
1036: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
1037: NEW_ORDER_QUANTITY= 0.0,
1038: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

Line 1061: Delete from msc_supplies

1057:
1058: -- For bug 6126698
1059: For c_rec in c10_d LOOP
1060:
1061: Delete from msc_supplies
1062: Where DISPOSITION_ID = c_rec.DISPOSITION_ID
1063: And organization_id = c_rec.organization_id
1064: And order_type = c_rec.order_type
1065: And sr_instance_id = MSC_CL_COLLECTION.v_instance_id

Line 1198: UPDATE MSC_SUPPLIES

1194:
1195: IF c_rec.SR_MTL_SUPPLY_ID<> -1 THEN
1196:
1197: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1198: UPDATE MSC_SUPPLIES
1199: SET
1200: OLD_DAILY_RATE= DAILY_RATE,
1201: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1202: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,

Line 1316: UPDATE MSC_SUPPLIES

1312: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP JOB');
1313:
1314:
1315: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1316: UPDATE MSC_SUPPLIES
1317: SET
1318: OLD_DAILY_RATE= DAILY_RATE,
1319: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1320: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,

Line 1441: UPDATE MSC_SUPPLIES

1437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP DSC JOB');
1438:
1439:
1440: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1441: UPDATE MSC_SUPPLIES
1442: SET
1443: OLD_DAILY_RATE= DAILY_RATE,
1444: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1445: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,

Line 1554: UPDATE MSC_SUPPLIES

1550:
1551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd REPT ITEMS');
1552:
1553: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1554: UPDATE MSC_SUPPLIES
1555: SET
1556: OLD_DAILY_RATE= DAILY_RATE,
1557: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1558: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,

Line 1656: UPDATE MSC_SUPPLIES

1652: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd OH');
1653:
1654:
1655: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1656: UPDATE MSC_SUPPLIES
1657: SET
1658: OLD_DAILY_RATE= DAILY_RATE,
1659: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1660: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,

Line 1710: UPDATE MSC_SUPPLIES

1706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd MPS');
1707:
1708:
1709: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1710: UPDATE MSC_SUPPLIES
1711: SET
1712: OLD_DAILY_RATE= DAILY_RATE,
1713: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1714: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,

Line 1822: UPDATE MSC_SUPPLIES

1818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd USUP');
1819:
1820:
1821: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1822: UPDATE MSC_SUPPLIES
1823: SET
1824: OLD_DAILY_RATE= DAILY_RATE,
1825: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1826: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,

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

2091:
2092: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQLCODE========================================');
2093: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2094: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2095: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2096: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2097:
2098: update msc_apps_instances
2099: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

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

2108:
2109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'OTHER========================================');
2110: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2111: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2114:
2115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2116: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

Line 2225: /* analyze msc_supplies here */

2221: COMMIT;
2222: END IF;
2223:
2224:
2225: /* analyze msc_supplies here */
2226: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
2227: IF MSC_CL_COLLECTION.v_exchange_mode= MSC_UTIL.SYS_YES THEN
2228: /* create temporay index */
2229: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN

Line 2791: ||' MSC_SUPPLIES_S.NEXTVAL,'

2787: ||' ACTIVITY_ITEM_ID'
2788: ||')'
2789: ||' VALUES '
2790: ||'( -1,'
2791: ||' MSC_SUPPLIES_S.NEXTVAL,'
2792: ||' :INVENTORY_ITEM_ID,'
2793: ||' :ORGANIZATION_ID,'
2794: ||' :FROM_ORGANIZATION_ID,'
2795: ||' :SR_INSTANCE_ID,'

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

3203:
3204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'P========================================');
3205: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3206: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3207: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3209:
3210: update msc_apps_instances
3211: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

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

3220:
3221: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'E========================================');
3222: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3223: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3224: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3226:
3227: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3228: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

Line 3282: -- msc_supplies. The same needs to be called in

3278:
3279: /* CP-ACK starts */
3280: --==============================================
3281: -- Call the API to load PO Supplier responses in
3282: -- msc_supplies. The same needs to be called in
3283: -- "else" section these code lines if contineous
3284: -- collections is enabled for this entity.
3285: --==============================================
3286: IF ( MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE

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

3957:
3958: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3959: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3960: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3961: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3963:
3964: update msc_apps_instances
3965: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

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

3974:
3975: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3976: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3977: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3978: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3979: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3980:
3981: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3982: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');

Line 4024: -- msc_supplies. The same needs to be called in

4020: END IF; -- IF ((MSC_CL_COLLECTION.v_coll_prec.mps_flag = SYS_YES and.....................
4021: /* CP-AUTO starts */
4022: --===================================================
4023: -- Call the API to load PO Supplier responses in
4024: -- msc_supplies. The same needs to be called in
4025: -- "else" section these code lines if contineous
4026: -- collections is enabled for this entity.
4027:
4028: -- We will call this API only if "Supplier Responses"

Line 4084: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_SUPPLIES '

4080:
4081: lv_temp_supply_tbl := 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
4082: lv_sql_stmt:=
4083: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_temp_supply_tbl
4084: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_SUPPLIES '
4085: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
4086: ||' AND plan_id = -1 AND ( ' ;
4087:
4088: -- agmcont:

Line 4333: || ' SELECT * from MSC_SUPPLIES '

4329:
4330: lv_copySQL_fixedpart :=
4331: 'INSERT INTO '
4332: || lv_temp_supply_tbl
4333: || ' SELECT * from MSC_SUPPLIES '
4334: || ' WHERE sr_instance_id = '
4335: || MSC_CL_COLLECTION.v_instance_id
4336: || ' AND plan_id = -1 ';
4337:

Line 4681: lv_supply_tbl:= 'MSC_SUPPLIES';

4677:
4678: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
4679: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
4680: ELSE
4681: lv_supply_tbl:= 'MSC_SUPPLIES';
4682: END IF;
4683:
4684:
4685: lv_sql_stmt:=

Line 4705: MSC_SUPPLIES_S.NEXTVAL,

4701: CREATION_DATE,
4702: CREATED_BY)
4703: SELECT
4704: -1 PLAN_ID,
4705: MSC_SUPPLIES_S.NEXTVAL,
4706: MOP.QUANTITY,
4707: MOP.SCHEDULED_PAYBACK_DATE,
4708: 1, -- FIRM_PLANNED_TYPE
4709: 29, -- order_type