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 505: lv_tbl:= 'MSC_SUPPLIES';

501:
502: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
503: lv_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
504: ELSE
505: lv_tbl:= 'MSC_SUPPLIES';
506: END IF;
507:
508: lv_sql_stmt:=
509: 'INSERT INTO '||lv_tbl

Line 643: ||' MSC_SUPPLIES_S.NEXTVAL,'

639: ||' REQ_LINE_ID'
640: ||' )'
641: ||'VALUES'
642: ||'( -1,'
643: ||' MSC_SUPPLIES_S.NEXTVAL,'
644: ||' :INVENTORY_ITEM_ID,'
645: ||' :ORGANIZATION_ID,'
646: ||' :FROM_ORGANIZATION_ID,'
647: ||' :SR_INSTANCE_ID,'

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

776: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply');
777:
778: IF MSC_CL_COLLECTION.v_is_complete_refresh AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
779:
780: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
781:
782: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
783: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
784: ELSE

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

779:
780: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
781:
782: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
783: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
784: ELSE
785: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
786: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
787: END IF;

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

782: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
783: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1);
784: ELSE
785: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
786: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
787: END IF;
788:
789: END IF;
790:

Line 801: /*UPDATE MSC_SUPPLIES

797: refresh.
798: In order to keep the transaction_id, set the quantitiy to zero
799: for delete. */
800:
801: /*UPDATE MSC_SUPPLIES
802: SET NEW_ORDER_QUANTITY= 0.0,
803: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
804: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
805: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 811: lv_sql_stmt1 := ' UPDATE MSC_SUPPLIES '

807: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
808: AND ORDER_TYPE= 11
809: AND SR_MTL_SUPPLY_ID= -1;*/
810:
811: lv_sql_stmt1 := ' UPDATE MSC_SUPPLIES '
812: ||' SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE, '
813: ||' OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY, '
814: ||' NEW_ORDER_QUANTITY= 0.0, '
815: ||' REFRESH_NUMBER= :v_last_collection_id, '

Line 850: UPDATE MSC_SUPPLIES ms

846:
847: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd PO-0');
848:
849:
850: UPDATE MSC_SUPPLIES ms
851: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
852: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
853: NEW_ORDER_QUANTITY= 0.0,
854: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

Line 872: UPDATE MSC_SUPPLIES ms

868: if c_rec.ORDER_TYPE = 70 then
869: MSC_CL_COLLECTION.link_top_transaction_id_req := TRUE;
870: end if;
871:
872: UPDATE MSC_SUPPLIES ms
873: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
874: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
875: NEW_ORDER_QUANTITY= 0.0,
876: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

Line 893: UPDATE MSC_SUPPLIES ms

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

Line 914: UPDATE MSC_SUPPLIES

910:
911: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP REPT ITEM-0');
912:
913:
914: UPDATE MSC_SUPPLIES
915: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
916: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
917: OLD_DAILY_RATE = DAILY_RATE,
918: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,

Line 938: UPDATE MSC_SUPPLIES

934:
935: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd OH-0');
936:
937:
938: UPDATE MSC_SUPPLIES
939: --SET NEW_ORDER_QUANTITY= 0.0,
940: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
941: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
942: NEW_ORDER_QUANTITY= NEW_ORDER_QUANTITY-c_rec.NEW_ORDER_QUANTITY, /*Bug: 2791310 */

Line 970: UPDATE MSC_SUPPLIES

966:
967: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd MPS-0');
968:
969:
970: UPDATE MSC_SUPPLIES
971: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
972: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
973: NEW_ORDER_QUANTITY= 0.0,
974: DAILY_RATE= 0.0,

Line 991: UPDATE MSC_SUPPLIES

987:
988: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd USUP-0');
989:
990:
991: UPDATE MSC_SUPPLIES
992: SET OLD_NEW_SCHEDULE_DATE = NEW_SCHEDULE_DATE,
993: OLD_NEW_ORDER_QUANTITY = NEW_ORDER_QUANTITY,
994: NEW_ORDER_QUANTITY= 0.0,
995: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

Line 1018: Delete from msc_supplies

1014:
1015: -- For bug 6126698
1016: For c_rec in c10_d LOOP
1017:
1018: Delete from msc_supplies
1019: Where DISPOSITION_ID = c_rec.DISPOSITION_ID
1020: And organization_id = c_rec.organization_id
1021: And order_type = c_rec.order_type
1022: And sr_instance_id = MSC_CL_COLLECTION.v_instance_id

Line 1144: UPDATE MSC_SUPPLIES

1140:
1141: IF c_rec.SR_MTL_SUPPLY_ID<> -1 THEN
1142:
1143: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1144: UPDATE MSC_SUPPLIES
1145: SET
1146: OLD_DAILY_RATE= DAILY_RATE,
1147: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1148: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,

Line 1262: UPDATE MSC_SUPPLIES

1258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP JOB');
1259:
1260:
1261: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1262: UPDATE MSC_SUPPLIES
1263: SET
1264: OLD_DAILY_RATE= DAILY_RATE,
1265: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1266: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,

Line 1378: UPDATE MSC_SUPPLIES

1374: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd WIP DSC JOB');
1375:
1376:
1377: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1378: UPDATE MSC_SUPPLIES
1379: SET
1380: OLD_DAILY_RATE= DAILY_RATE,
1381: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1382: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,

Line 1491: UPDATE MSC_SUPPLIES

1487:
1488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd REPT ITEMS');
1489:
1490: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1491: UPDATE MSC_SUPPLIES
1492: SET
1493: OLD_DAILY_RATE= DAILY_RATE,
1494: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1495: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,

Line 1593: UPDATE MSC_SUPPLIES

1589: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd OH');
1590:
1591:
1592: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1593: UPDATE MSC_SUPPLIES
1594: SET
1595: OLD_DAILY_RATE= DAILY_RATE,
1596: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1597: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,

Line 1647: UPDATE MSC_SUPPLIES

1643: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd MPS');
1644:
1645:
1646: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1647: UPDATE MSC_SUPPLIES
1648: SET
1649: OLD_DAILY_RATE= DAILY_RATE,
1650: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1651: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,

Line 1759: UPDATE MSC_SUPPLIES

1755: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'load_supply: upd USUP');
1756:
1757:
1758: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1759: UPDATE MSC_SUPPLIES
1760: SET
1761: OLD_DAILY_RATE= DAILY_RATE,
1762: OLD_FIRST_UNIT_START_DATE= FIRST_UNIT_START_DATE,
1763: OLD_LAST_UNIT_COMPLETION_DATE= LAST_UNIT_COMPLETION_DATE,

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

2019:
2020: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQLCODE========================================');
2021: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2022: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2023: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2025:
2026: update msc_apps_instances
2027: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

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

2036:
2037: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'OTHER========================================');
2038: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2039: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
2040: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
2041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2042:
2043: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2044: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

Line 2117: /* analyze msc_supplies here */

2113: COMMIT;
2114: END IF;
2115:
2116:
2117: /* analyze msc_supplies here */
2118: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
2119: IF MSC_CL_COLLECTION.v_exchange_mode= MSC_UTIL.SYS_YES THEN
2120: /* create temporay index */
2121: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN

Line 2649: ||' MSC_SUPPLIES_S.NEXTVAL,'

2645: ||' REQ_LINE_ID'
2646: ||')'
2647: ||' VALUES '
2648: ||'( -1,'
2649: ||' MSC_SUPPLIES_S.NEXTVAL,'
2650: ||' :INVENTORY_ITEM_ID,'
2651: ||' :ORGANIZATION_ID,'
2652: ||' :FROM_ORGANIZATION_ID,'
2653: ||' :SR_INSTANCE_ID,'

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

3043:
3044: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'P========================================');
3045: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3046: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3047: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3048: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3049:
3050: update msc_apps_instances
3051: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

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

3060:
3061: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'E========================================');
3062: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3063: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_STAGING_SUPPLY');
3064: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3066:
3067: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3068: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

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

3101:
3102: /* CP-ACK starts */
3103: --==============================================
3104: -- Call the API to load PO Supplier responses in
3105: -- msc_supplies. The same needs to be called in
3106: -- "else" section these code lines if contineous
3107: -- collections is enabled for this entity.
3108: --==============================================
3109: IF ( MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE

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

3734:
3735: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3736: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3737: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3738: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3739: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3740:
3741: update msc_apps_instances
3742: set SUPPLIES_LOAD_FLAG = MSC_CL_COLLECTION.G_JOB_ERROR

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

3751:
3752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3753: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3754: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3755: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIES');
3756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3757:
3758: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3759: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_COLLECTION.ITEM_NAME');

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

3797: END IF; -- IF ((MSC_CL_COLLECTION.v_coll_prec.mps_flag = SYS_YES and.....................
3798: /* CP-AUTO starts */
3799: --===================================================
3800: -- Call the API to load PO Supplier responses in
3801: -- msc_supplies. The same needs to be called in
3802: -- "else" section these code lines if contineous
3803: -- collections is enabled for this entity.
3804:
3805: -- We will call this API only if "Supplier Responses"

Line 3846: ||' SELECT * from MSC_SUPPLIES '

3842:
3843: lv_temp_supply_tbl := 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
3844: lv_sql_stmt:=
3845: 'INSERT INTO '||lv_temp_supply_tbl
3846: ||' SELECT * from MSC_SUPPLIES '
3847: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
3848: ||' AND plan_id = -1 '
3849: ||' AND order_type NOT IN (';
3850:

Line 4016: ||' SELECT * from MSC_SUPPLIES '

4012: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
4013: null;
4014: ELSE
4015: lv_sql_stmt1:= ' UNION ALL '
4016: ||' SELECT * from MSC_SUPPLIES '
4017: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
4018: ||' AND plan_id = -1 '
4019: ||' AND organization_id not '||MSC_UTIL.v_in_org_str
4020: ||' AND order_type IN (';

Line 4062: lv_supply_tbl:= 'MSC_SUPPLIES';

4058:
4059: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
4060: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
4061: ELSE
4062: lv_supply_tbl:= 'MSC_SUPPLIES';
4063: END IF;
4064:
4065:
4066: lv_sql_stmt:=

Line 4086: MSC_SUPPLIES_S.NEXTVAL,

4082: CREATION_DATE,
4083: CREATED_BY)
4084: SELECT
4085: -1 PLAN_ID,
4086: MSC_SUPPLIES_S.NEXTVAL,
4087: MOP.QUANTITY,
4088: MOP.SCHEDULED_PAYBACK_DATE,
4089: 1, -- FIRM_PLANNED_TYPE
4090: 29, -- order_type