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_DEMAND_ODS_LOAD dependencies on MSC_DEMANDS

Line 547: lv_tbl:= 'MSC_DEMANDS';

543: msc_analyse_tables_pk.analyse_table( 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code, MSC_CL_COLLECTION.v_instance_id, -1);
544:
545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index DEMANDS_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');
546: ELSE
547: lv_tbl:= 'MSC_DEMANDS';
548: END IF;
549:
550: /* select the link_to_line_id and its corresponding demand_id into Collection variables */
551:

Line 701: lv_tbl:= 'MSC_DEMANDS';

697:
698: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
699: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
700: ELSE
701: lv_tbl:= 'MSC_DEMANDS';
702: END IF;
703:
704: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
705: BEGIN

Line 744: ||' MSC_DEMANDS_S.nextval,'

740: ||' CREATION_DATE,'
741: ||' CREATED_BY) '
742: ||' SELECT '
743: ||' -1,'
744: ||' MSC_DEMANDS_S.nextval,'
745: ||' msd.demand_type,'
746: ||' msd.ORIGINATION_TYPE,'
747: ||' t1.INVENTORY_ITEM_ID,'
748: ||' msd.ORGANIZATION_ID,'

Line 805: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

801:
802: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
803: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
804: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
805: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
806: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
807:
808: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
809: RAISE;

Line 816: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

812: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
814: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
815: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
816: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
817: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
819: END IF;
820: END;

Line 861: ||' MSC_DEMANDS_S.nextval,'

857: ||' CREATION_DATE,'
858: ||' CREATED_BY) '
859: ||'VALUES'
860: ||'( -1,'
861: ||' MSC_DEMANDS_S.nextval,'
862: ||' :DEMAND_TYPE,'
863: ||' :ORIGINATION_TYPE,'
864: ||' :INVENTORY_ITEM_ID,'
865: ||' :ORGANIZATION_ID,'

Line 900: DELETE MSC_DEMANDS

896:
897: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
898: FOR c_rec in c1_d LOOP
899:
900: DELETE MSC_DEMANDS
901: WHERE PLAN_ID= -1
902: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
903: AND ORIGINATION_TYPE= c_rec.ORIGINATION_TYPE
904: AND SALES_ORDER_LINE_ID = c_rec.SALES_ORDER_LINE_ID

Line 917: UPDATE MSC_DEMANDS

913: BEGIN
914:
915: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
916: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
917: UPDATE MSC_DEMANDS
918: SET
919: INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID,
920: ORGANIZATION_ID= c_rec.ORGANIZATION_ID,
921: OLD_USING_REQUIREMENT_QUANTITY= USING_REQUIREMENT_QUANTITY,

Line 1004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

1000:
1001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1002: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1003: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1004: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1006:
1007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1008: RAISE;

Line 1016: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

1012:
1013: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1014: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1015: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1016: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1018:
1019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1020: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

Line 1346: defined as varchar(62) in msc_demands table */

1342: -- ==============================================================
1343: PROCEDURE LOAD_DEMAND IS
1344:
1345: /* 2201791 - select substr(order_number,1,62) since order_number is
1346: defined as varchar(62) in msc_demands table */
1347:
1348: CURSOR c1 IS
1349: SELECT
1350: t1.INVENTORY_ITEM_ID,

Line 1479: lv_tbl:= 'MSC_DEMANDS';

1475: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1476: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
1477: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1478: ELSE
1479: lv_tbl:= 'MSC_DEMANDS';
1480: lv_supply_tbl:= 'MSC_SUPPLIES';
1481: END IF;
1482:
1483: /** PREPLACE CHANGE START **/

Line 1569: ||' MSC_DEMANDS_S.nextval,'

1565: ||' SHIP_TO_LOCATION_ID,'
1566: ||' SHIPPING_METHOD_CODE)'
1567: ||'VALUES'
1568: ||'( -1,'
1569: ||' MSC_DEMANDS_S.nextval,'
1570: ||' :INVENTORY_ITEM_ID,'
1571: ||' :ORGANIZATION_ID,'
1572: ||' :SCHEDULE_DESIGNATOR_ID,'
1573: ||' :USING_ASSEMBLY_ITEM_ID,'

Line 1763: UPDATE MSC_DEMANDS

1759: IF lb_ORIGINATION_TYPE(j) IN ( 6,7,15,24,42) THEN
1760:
1761: IF lb_DELETED_FLAG(j) = MSC_UTIL.SYS_YES THEN
1762:
1763: UPDATE MSC_DEMANDS
1764: SET USING_REQUIREMENT_QUANTITY= 0,
1765: DAILY_DEMAND_RATE= 0,
1766: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1767: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

Line 1778: UPDATE MSC_DEMANDS

1774:
1775: ELSE
1776:
1777: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1778: UPDATE MSC_DEMANDS
1779: SET
1780: INVENTORY_ITEM_ID= lb_INVENTORY_ITEM_ID(j),
1781: ORGANIZATION_ID= lb_ORGANIZATION_ID(j),
1782: OLD_USING_REQUIREMENT_QUANTITY= lb_USING_REQUIREMENT_QUANTITY(j),

Line 1835: UPDATE MSC_DEMANDS

1831: ELSIF lb_ORIGINATION_TYPE(j)=8 THEN /* Manual MDS */
1832:
1833: IF lb_DELETED_FLAG(j)= MSC_UTIL.SYS_YES THEN
1834:
1835: UPDATE MSC_DEMANDS
1836: SET USING_REQUIREMENT_QUANTITY= 0,
1837: DAILY_DEMAND_RATE= 0,
1838: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
1839: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

Line 1850: UPDATE MSC_DEMANDS

1846:
1847: ELSE
1848:
1849: /* ATP SUMMARY CHANGES Added the OLD_**** Columns */
1850: UPDATE MSC_DEMANDS
1851: SET
1852: INVENTORY_ITEM_ID= lb_INVENTORY_ITEM_ID(j),
1853: ORGANIZATION_ID= lb_ORGANIZATION_ID(j),
1854: OLD_USING_REQUIREMENT_QUANTITY= lb_USING_REQUIREMENT_QUANTITY(j),

Line 1980: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

1976:
1977: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1978: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1979: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
1980: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1981: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1982:
1983: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1984: RAISE;

Line 1993: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

1989:
1990: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1991: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1992: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
1993: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1995:
1996: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1997: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

Line 2041: /* call the function to link the Demand_id and Parent_id in MSC_DEMANDS

2037: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN COMMIT; END IF;
2038:
2039: IF (MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115) then
2040: IF (MSC_CL_COLLECTION.v_is_incremental_refresh) OR (MSC_CL_COLLECTION.v_is_cont_refresh and MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_INCR) THEN --Version
2041: /* call the function to link the Demand_id and Parent_id in MSC_DEMANDS
2042: if mds is incremental*/
2043: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_NO;
2044: IF MSC_CL_DEMAND_ODS_LOAD.LINK_PARENT_SALES_ORDERS_MDS THEN
2045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Linking of Sales Order line in MDS to its Parent Sales orders is successful.....');

Line 2297: ' ,MSC_DEMANDS_S.nextval DEMAND_ID ';

2293: so.INTRANSIT_LEAD_TIME,
2294: so.customer_id sr_customer_acct_id ,
2295: so.DEMAND_SOURCE_LINE SR_SO_LINEID ';
2296: lv_sql1_2 :=
2297: ' ,MSC_DEMANDS_S.nextval DEMAND_ID ';
2298:
2299: lv_sql1_3:='
2300: FROM MSC_ITEM_ID_LID t1,
2301: MSC_ITEM_ID_LID t2,

Line 2532: MSC_DEMANDS_S.nextval ) ';

2528: s.SHIPPING_METHOD_CODE,
2529: s.INTRANSIT_LEAD_TIME,
2530: s.sr_customer_acct_id,
2531: s.DEMAND_SOURCE_LINE,
2532: MSC_DEMANDS_S.nextval ) ';
2533:
2534:
2535: -- row type1
2536: IF MSC_CL_COLLECTION.v_is_so_incremental_refresh THEN -- for netchg Coll

Line 3253: ||' SELECT * from MSC_DEMANDS '

3249:
3250: lv_temp_demand_tbl := 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
3251: lv_sql_stmt:=
3252: 'INSERT INTO '||lv_temp_demand_tbl
3253: ||' SELECT * from MSC_DEMANDS '
3254: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
3255: ||' AND plan_id = -1 '
3256: ||' AND origination_type NOT IN (';
3257:

Line 3380: ||' SELECT * from MSC_DEMANDS '

3376: null;
3377: ELSE
3378:
3379: lv_sql_stmt1:= ' UNION ALL '
3380: ||' SELECT * from MSC_DEMANDS '
3381: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
3382: ||' AND plan_id = -1 '
3383: ||' AND organization_id NOT '||MSC_UTIL.v_in_org_str
3384: ||' AND origination_type IN (';

Line 3414: ||' SELECT * from MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_depot_org_str;

3410:
3411: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_YES) AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_NO) AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
3412:
3413: lv_sql_stmt2 := 'INSERT INTO '||lv_temp_demand_tbl
3414: ||' SELECT * from MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_depot_org_str;
3415:
3416: EXECUTE IMMEDIATE lv_sql_stmt2;
3417:
3418: Commit ;

Line 3424: ||' SELECT * from MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_non_depot_org_str;

3420:
3421: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_NO) AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_YES) AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
3422:
3423: lv_sql_stmt2 := 'INSERT INTO '||lv_temp_demand_tbl
3424: ||' SELECT * from MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_non_depot_org_str;
3425:
3426: EXECUTE IMMEDIATE lv_sql_stmt2;
3427:
3428: Commit ;

Line 3450: lv_tbl:= 'MSC_DEMANDS';

3446:
3447: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
3448: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
3449: ELSE
3450: lv_tbl:= 'MSC_DEMANDS';
3451: END IF;
3452:
3453:
3454: lv_sql_ins :=

Line 3475: MSC_DEMANDS_S.nextval,

3471: CREATION_DATE,
3472: CREATED_BY)
3473: SELECT
3474: -1 PLAN_ID,
3475: MSC_DEMANDS_S.nextval,
3476: MOP. QUANTITY,
3477: SCHEDULED_PAYBACK_DATE,
3478: 1 DEMAND_TYPE,
3479: 27 ORIGINATION_TYPE,