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_SALES_ORDERS

Line 31: from msc_sales_orders

27:
28:
29: cursor link_supply_demand is
30: select ROWID,INVENTORY_ITEM_ID,CUST_PO_NUMBER, SUPPLY_ID,CUSTOMER_LINE_NUMBER,SALES_ORDER_NUMBER
31: from msc_sales_orders
32: where demand_source_type = 2
33: and reservation_type = 1
34: and cust_po_number <> '-1'
35: and customer_line_number <> '-1'

Line 82: /*Update msc_sales_orders

78:
79:
80:
81:
82: /*Update msc_sales_orders
83: set supply_id = lv_supply_id,
84: source_organization_id = lv_source_organization_id,
85: source_org_instance_id = lv_source_sr_instance_id
86: where rowid = c_rec.rowid;

Line 113: /*Update msc_sales_orders

109: EXECUTE IMMEDIATE lv_supply_stmt
110: INTO lv_supply_id, lv_source_organization_id, lv_source_sr_instance_id
111: USING c_rec.CUST_PO_NUMBER||'(1)', c_rec.CUSTOMER_LINE_NUMBER,c_rec.INVENTORY_ITEM_ID,c_rec.CUST_PO_NUMBER||'(2)', c_rec.CUSTOMER_LINE_NUMBER,c_rec.INVENTORY_ITEM_ID;
112:
113: /*Update msc_sales_orders
114: set supply_id = lv_supply_id,
115: source_organization_id = lv_source_organization_id,
116: source_org_instance_id = lv_source_sr_instance_id
117: where rowid = c_rec.rowid; */

Line 129: Update msc_sales_orders

125: NULL;
126: END;
127:
128: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Hoping its coming before the end loop:'||c_rec.sales_order_number||'inst='||to_char(MSC_CL_COLLECTION.v_instance_id) );
129: Update msc_sales_orders
130: set supply_id = lv_supply_id,
131: source_organization_id = lv_source_organization_id,
132: source_org_instance_id = lv_source_sr_instance_id
133: where rowid = c_rec.rowid;

Line 158: from msc_sales_orders

154: select SR_INSTANCE_ID,INVENTORY_ITEM_ID,ORGANIZATION_ID,
155: DEMAND_SOURCE_TYPE,DEMAND_SOURCE_HEADER_ID,reservation_type,
156: original_system_reference ,original_system_line_reference, supply_id,
157: sales_order_number
158: from msc_sales_orders
159: where sr_instance_id = c_instance_id
160: and demand_source_type = 8
161: and reservation_type = 1
162: and original_system_reference <> '-1'

Line 205: Update msc_sales_orders

201: EXECUTE IMMEDIATE lv_supply_stmt
202: INTO lv_supply_id, lv_source_organization_id, lv_source_sr_instance_id
203: USING c_rec.ORIGINAL_SYSTEM_REFERENCE,c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE;
204:
205: Update msc_sales_orders
206: set supply_id = lv_supply_id
207: /*source_organization_id = lv_source_organization_id,
208: source_org_instance_id = lv_source_sr_instance_id*/
209: where sr_instance_id = MSC_CL_COLLECTION.v_instance_id

Line 251: from msc_sales_orders

247: original_system_reference ,original_system_line_reference, supply_id,
248: sales_order_number,
249: -- Bug 14318618
250: demand_source_line
251: from msc_sales_orders
252: where sr_instance_id = c_instance_id
253: and demand_source_type = 8
254: and reservation_type = 1
255: and original_system_reference <> '-1';

Line 299: Update msc_sales_orders

295: EXECUTE IMMEDIATE lv_supply_stmt
296: INTO lv_supply_id, lv_source_organization_id, lv_source_sr_instance_id
297: USING c_rec.ORIGINAL_SYSTEM_REFERENCE,c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE;
298:
299: Update msc_sales_orders
300: set supply_id = lv_supply_id
301: /*source_organization_id = lv_source_organization_id,
302: source_org_instance_id = lv_source_sr_instance_id*/
303: where sr_instance_id = MSC_CL_COLLECTION.v_instance_id

Line 458: IF (MSC_CL_COLLECTION.v_so_exchange_mode= MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.is_msctbl_partitioned('MSC_SALES_ORDERS') ) THEN

454: BEGIN
455:
456: lv_task_start_time := SYSDATE;
457:
458: IF (MSC_CL_COLLECTION.v_so_exchange_mode= MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.is_msctbl_partitioned('MSC_SALES_ORDERS') ) THEN
459: lv_exchange_mode := MSC_UTIL.SYS_YES;
460: END IF;
461:
462: IF lv_exchange_mode=MSC_UTIL.SYS_YES THEN

Line 481: lv_tbl:= 'MSC_SALES_ORDERS';

477: msc_analyse_tables_pk.analyse_table( 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code, MSC_CL_COLLECTION.v_instance_id, -1);
478:
479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');
480: ELSE
481: lv_tbl:= 'MSC_SALES_ORDERS';
482: END IF;
483:
484: /* select the link_to_line_id and its corresponding demand_id into Collection variables */
485:

Line 515: in msc_sales_orders Table with the Demand_id of the Parent line_id */

511:
512: EXIT WHEN c1%NOTFOUND;
513:
514: /* If the above select clause has more than 1 row , Update the PARENT_ID
515: in msc_sales_orders Table with the Demand_id of the Parent line_id */
516:
517: EXECUTE IMMEDIATE
518: ' UPDATE ' || lv_tbl
519: ||' SET parent_id = :demand_id_value '

Line 634: in msc_sales_orders Table with the Demand_id of the Parent line_id */

630:
631: EXIT WHEN c1%NOTFOUND;
632:
633: /* If the above select clause has more than 1 row , Update the PARENT_ID
634: in msc_sales_orders Table with the Demand_id of the Parent line_id */
635:
636: EXECUTE IMMEDIATE
637: ' UPDATE ' || lv_tbl
638: ||' SET parent_id = :demand_id_value '

Line 2404: MSC_CL_COLLECTION.is_msctbl_partitioned('MSC_SALES_ORDERS') THEN

2400: BEGIN
2401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' LOAD_SALES_ORDER started');
2402:
2403: IF MSC_CL_COLLECTION.v_so_exchange_mode= MSC_UTIL.SYS_YES AND
2404: MSC_CL_COLLECTION.is_msctbl_partitioned('MSC_SALES_ORDERS') THEN
2405: lv_exchange_mode := MSC_UTIL.SYS_YES;
2406: END IF;
2407:
2408: IF lv_exchange_mode=MSC_UTIL.SYS_YES THEN

Line 2412: lv_tbl:= 'MSC_SALES_ORDERS';

2408: IF lv_exchange_mode=MSC_UTIL.SYS_YES THEN
2409: lv_tbl:= 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code;
2410: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2411: ELSE
2412: lv_tbl:= 'MSC_SALES_ORDERS';
2413: lv_supply_tbl:= 'MSC_SUPPLIES';
2414: END IF;
2415:
2416: /** PREPLACE CHANGE START **/

Line 2458: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', MSC_CL_COLLECTION.v_instance_id,NULL);

2454:
2455: IF lv_exchange_mode=MSC_UTIL.SYS_NO THEN
2456:
2457: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2458: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', MSC_CL_COLLECTION.v_instance_id,NULL);
2459: ELSE
2460: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2461: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);
2462: END IF;

Line 2461: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);

2457: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2458: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', MSC_CL_COLLECTION.v_instance_id,NULL);
2459: ELSE
2460: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2461: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);
2462: END IF;
2463:
2464: END IF;
2465:

Line 2474: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_SALES_ORDERS'

2470: lv_tbl:= 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code;
2471:
2472: lv_sql_stmt:=
2473: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
2474: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_SALES_ORDERS'
2475: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2476: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2477:
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

Line 2493: DELETE FROM MSC_SALES_ORDERS

2489:
2490: ELSE
2491:
2492: LOOP
2493: DELETE FROM MSC_SALES_ORDERS
2494: WHERE ROW_TYPE = 3
2495: AND sr_instance_id = MSC_CL_COLLECTION.v_instance_id
2496: AND SR_DEMAND_ID IN (SELECT so.DEMAND_ID
2497: FROM MSC_ST_SALES_ORDERS so

Line 2507: DELETE FROM MSC_SALES_ORDERS

2503: COMMIT;
2504: END LOOP;
2505:
2506: LOOP
2507: DELETE FROM MSC_SALES_ORDERS
2508: WHERE SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
2509: AND (ROW_TYPE,SR_DEMAND_ID) IN (SELECT so.ROW_TYPE,so.DEMAND_ID
2510: FROM MSC_ST_SALES_ORDERS so
2511: WHERE so.DELETED_FLAG = 1

Line 2945: UPDATE MSC_SALES_ORDERS

2941: and msso.demand_source_line IS NOT NULL
2942: and msso.reservation_type = 2
2943: and msso.deleted_flag=MSC_UTIL.SYS_NO )
2944: LOOP
2945: UPDATE MSC_SALES_ORDERS
2946: SET RESERVATION_QUANTITY = ( SELECT SUM(NVL(mso.primary_uom_quantity,0))
2947: FROM msc_sales_orders mso
2948: WHERE mso.sr_instance_id= MSC_CL_COLLECTION.v_instance_id
2949: AND mso.reservation_type = 2

Line 2947: FROM msc_sales_orders mso

2943: and msso.deleted_flag=MSC_UTIL.SYS_NO )
2944: LOOP
2945: UPDATE MSC_SALES_ORDERS
2946: SET RESERVATION_QUANTITY = ( SELECT SUM(NVL(mso.primary_uom_quantity,0))
2947: FROM msc_sales_orders mso
2948: WHERE mso.sr_instance_id= MSC_CL_COLLECTION.v_instance_id
2949: AND mso.reservation_type = 2
2950: AND ROW_TYPE=1
2951: AND mso.demand_source_line = modified_resv.demand_source_line ),

Line 3026: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');

3022:
3023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3024: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3025: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');
3026: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
3027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3028:
3029: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3030: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');