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 30: from msc_sales_orders

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

Line 80: Update msc_sales_orders

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

Line 119: from msc_sales_orders

115: select SR_INSTANCE_ID,INVENTORY_ITEM_ID,ORGANIZATION_ID,
116: DEMAND_SOURCE_TYPE,DEMAND_SOURCE_HEADER_ID,reservation_type,
117: original_system_reference ,original_system_line_reference, supply_id,
118: sales_order_number
119: from msc_sales_orders
120: where sr_instance_id = c_instance_id
121: and demand_source_type = 8
122: and reservation_type = 1
123: and original_system_reference <> '-1'

Line 164: Update msc_sales_orders

160: EXECUTE IMMEDIATE lv_supply_stmt
161: INTO lv_supply_id, lv_source_organization_id, lv_source_sr_instance_id
162: USING c_rec.ORIGINAL_SYSTEM_REFERENCE,c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE;
163:
164: Update msc_sales_orders
165: set supply_id = lv_supply_id,
166: source_organization_id = lv_source_organization_id,
167: source_org_instance_id = lv_source_sr_instance_id
168: where sr_instance_id = MSC_CL_COLLECTION.v_instance_id

Line 208: from msc_sales_orders

204: select SR_INSTANCE_ID,INVENTORY_ITEM_ID,ORGANIZATION_ID,
205: DEMAND_SOURCE_TYPE,DEMAND_SOURCE_HEADER_ID,reservation_type,
206: original_system_reference ,original_system_line_reference, supply_id,
207: sales_order_number
208: from msc_sales_orders
209: where sr_instance_id = c_instance_id
210: and demand_source_type = 8
211: and reservation_type = 1
212: and original_system_reference <> '-1'

Line 253: Update msc_sales_orders

249: EXECUTE IMMEDIATE lv_supply_stmt
250: INTO lv_supply_id, lv_source_organization_id, lv_source_sr_instance_id
251: USING c_rec.ORIGINAL_SYSTEM_REFERENCE,c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE;
252:
253: Update msc_sales_orders
254: set supply_id = lv_supply_id,
255: source_organization_id = lv_source_organization_id,
256: source_org_instance_id = lv_source_sr_instance_id
257: where sr_instance_id = MSC_CL_COLLECTION.v_instance_id

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

406: BEGIN
407:
408: lv_task_start_time := SYSDATE;
409:
410: IF (MSC_CL_COLLECTION.v_so_exchange_mode= MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.is_msctbl_partitioned('MSC_SALES_ORDERS') ) THEN
411: lv_exchange_mode := MSC_UTIL.SYS_YES;
412: END IF;
413:
414: IF lv_exchange_mode=MSC_UTIL.SYS_YES THEN

Line 433: lv_tbl:= 'MSC_SALES_ORDERS';

429: msc_analyse_tables_pk.analyse_table( 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code, MSC_CL_COLLECTION.v_instance_id, -1);
430:
431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');
432: ELSE
433: lv_tbl:= 'MSC_SALES_ORDERS';
434: END IF;
435:
436: /* select the link_to_line_id and its corresponding demand_id into Collection variables */
437:

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

463:
464: EXIT WHEN c1%NOTFOUND;
465:
466: /* If the above select clause has more than 1 row , Update the PARENT_ID
467: in msc_sales_orders Table with the Demand_id of the Parent line_id */
468:
469: EXECUTE IMMEDIATE
470: ' UPDATE ' || lv_tbl
471: ||' SET parent_id = :demand_id_value '

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

582:
583: EXIT WHEN c1%NOTFOUND;
584:
585: /* If the above select clause has more than 1 row , Update the PARENT_ID
586: in msc_sales_orders Table with the Demand_id of the Parent line_id */
587:
588: EXECUTE IMMEDIATE
589: ' UPDATE ' || lv_tbl
590: ||' SET parent_id = :demand_id_value '

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

2101: BEGIN
2102: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' LOAD_SALES_ORDER started');
2103:
2104: IF MSC_CL_COLLECTION.v_so_exchange_mode= MSC_UTIL.SYS_YES AND
2105: MSC_CL_COLLECTION.is_msctbl_partitioned('MSC_SALES_ORDERS') THEN
2106: lv_exchange_mode := MSC_UTIL.SYS_YES;
2107: END IF;
2108:
2109: IF lv_exchange_mode=MSC_UTIL.SYS_YES THEN

Line 2113: lv_tbl:= 'MSC_SALES_ORDERS';

2109: IF lv_exchange_mode=MSC_UTIL.SYS_YES THEN
2110: lv_tbl:= 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code;
2111: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2112: ELSE
2113: lv_tbl:= 'MSC_SALES_ORDERS';
2114: lv_supply_tbl:= 'MSC_SUPPLIES';
2115: END IF;
2116:
2117: /** PREPLACE CHANGE START **/

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

2153:
2154: IF lv_exchange_mode=MSC_UTIL.SYS_NO THEN
2155:
2156: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2157: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', MSC_CL_COLLECTION.v_instance_id,NULL);
2158: ELSE
2159: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2160: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);
2161: END IF;

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

2156: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2157: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', MSC_CL_COLLECTION.v_instance_id,NULL);
2158: ELSE
2159: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2160: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);
2161: END IF;
2162:
2163: END IF;
2164:

Line 2173: ||' SELECT * from MSC_SALES_ORDERS'

2169: lv_tbl:= 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code;
2170:
2171: lv_sql_stmt:=
2172: 'INSERT INTO '||lv_tbl
2173: ||' SELECT * from MSC_SALES_ORDERS'
2174: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2175: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2176:
2177: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

Line 2192: DELETE FROM MSC_SALES_ORDERS

2188:
2189: ELSE
2190:
2191: LOOP
2192: DELETE FROM MSC_SALES_ORDERS
2193: WHERE ROW_TYPE = 3
2194: AND sr_instance_id = MSC_CL_COLLECTION.v_instance_id
2195: AND SR_DEMAND_ID IN (SELECT so.DEMAND_ID
2196: FROM MSC_ST_SALES_ORDERS so

Line 2206: DELETE FROM MSC_SALES_ORDERS

2202: COMMIT;
2203: END LOOP;
2204:
2205: LOOP
2206: DELETE FROM MSC_SALES_ORDERS
2207: WHERE SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
2208: AND (ROW_TYPE,SR_DEMAND_ID) IN (SELECT so.ROW_TYPE,so.DEMAND_ID
2209: FROM MSC_ST_SALES_ORDERS so
2210: WHERE so.DELETED_FLAG = 1

Line 2613: UPDATE MSC_SALES_ORDERS

2609: and msso.demand_source_line IS NOT NULL
2610: and msso.reservation_type = 2
2611: and msso.deleted_flag=MSC_UTIL.SYS_NO )
2612: LOOP
2613: UPDATE MSC_SALES_ORDERS
2614: SET RESERVATION_QUANTITY = ( SELECT SUM(NVL(mso.primary_uom_quantity,0))
2615: FROM msc_sales_orders mso
2616: WHERE mso.sr_instance_id= MSC_CL_COLLECTION.v_instance_id
2617: AND mso.reservation_type = 2

Line 2615: FROM msc_sales_orders mso

2611: and msso.deleted_flag=MSC_UTIL.SYS_NO )
2612: LOOP
2613: UPDATE MSC_SALES_ORDERS
2614: SET RESERVATION_QUANTITY = ( SELECT SUM(NVL(mso.primary_uom_quantity,0))
2615: FROM msc_sales_orders mso
2616: WHERE mso.sr_instance_id= MSC_CL_COLLECTION.v_instance_id
2617: AND mso.reservation_type = 2
2618: AND ROW_TYPE=1
2619: AND mso.demand_source_line = modified_resv.demand_source_line ),

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

2690:
2691: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2692: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2693: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');
2694: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
2695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
2696:
2697: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2698: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');