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_WS_SNO_PUBLISH dependencies on MSC_INT_SRC_RECOMMEND_DETAIL

Line 423: -- TO_NUMBER(msc_int_src_recommend_detail.planName),

419: -- inventory_item_id,
420: -- source_organization_id,
421: -- source_org_instance_id )
422: --SELECT DISTINCT
423: -- TO_NUMBER(msc_int_src_recommend_detail.planName),
424: --sr_instance_id
425: -- TO_NUMBER(substr(msc_int_src_recommend_detail.destination_code,1,instr(msc_int_src_recommend_detail.destination_code,':',1,1)-1)),
426: --organization_id
427: -- TO_NUMBER(substr(msc_int_src_recommend_detail.destination_code,instr(msc_int_src_recommend_detail.destination_code,':',1,1)+1)),

Line 425: -- TO_NUMBER(substr(msc_int_src_recommend_detail.destination_code,1,instr(msc_int_src_recommend_detail.destination_code,':',1,1)-1)),

421: -- source_org_instance_id )
422: --SELECT DISTINCT
423: -- TO_NUMBER(msc_int_src_recommend_detail.planName),
424: --sr_instance_id
425: -- TO_NUMBER(substr(msc_int_src_recommend_detail.destination_code,1,instr(msc_int_src_recommend_detail.destination_code,':',1,1)-1)),
426: --organization_id
427: -- TO_NUMBER(substr(msc_int_src_recommend_detail.destination_code,instr(msc_int_src_recommend_detail.destination_code,':',1,1)+1)),
428: --inventory_item_id
429: -- TO_NUMBER(substr(msc_int_src_recommend_detail.item_code,instr(msc_int_src_recommend_detail.item_code,':',1,1)+1)),

Line 427: -- TO_NUMBER(substr(msc_int_src_recommend_detail.destination_code,instr(msc_int_src_recommend_detail.destination_code,':',1,1)+1)),

423: -- TO_NUMBER(msc_int_src_recommend_detail.planName),
424: --sr_instance_id
425: -- TO_NUMBER(substr(msc_int_src_recommend_detail.destination_code,1,instr(msc_int_src_recommend_detail.destination_code,':',1,1)-1)),
426: --organization_id
427: -- TO_NUMBER(substr(msc_int_src_recommend_detail.destination_code,instr(msc_int_src_recommend_detail.destination_code,':',1,1)+1)),
428: --inventory_item_id
429: -- TO_NUMBER(substr(msc_int_src_recommend_detail.item_code,instr(msc_int_src_recommend_detail.item_code,':',1,1)+1)),
430: --source_organization_id
431: -- TO_NUMBER(substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )),

Line 429: -- TO_NUMBER(substr(msc_int_src_recommend_detail.item_code,instr(msc_int_src_recommend_detail.item_code,':',1,1)+1)),

425: -- TO_NUMBER(substr(msc_int_src_recommend_detail.destination_code,1,instr(msc_int_src_recommend_detail.destination_code,':',1,1)-1)),
426: --organization_id
427: -- TO_NUMBER(substr(msc_int_src_recommend_detail.destination_code,instr(msc_int_src_recommend_detail.destination_code,':',1,1)+1)),
428: --inventory_item_id
429: -- TO_NUMBER(substr(msc_int_src_recommend_detail.item_code,instr(msc_int_src_recommend_detail.item_code,':',1,1)+1)),
430: --source_organization_id
431: -- TO_NUMBER(substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )),
432: ---source_org_instance_id
433: -- TO_NUMBER(substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1))

Line 431: -- TO_NUMBER(substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )),

427: -- TO_NUMBER(substr(msc_int_src_recommend_detail.destination_code,instr(msc_int_src_recommend_detail.destination_code,':',1,1)+1)),
428: --inventory_item_id
429: -- TO_NUMBER(substr(msc_int_src_recommend_detail.item_code,instr(msc_int_src_recommend_detail.item_code,':',1,1)+1)),
430: --source_organization_id
431: -- TO_NUMBER(substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )),
432: ---source_org_instance_id
433: -- TO_NUMBER(substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1))
434: --FROM msc_int_src_recommend_detail
435: --WHERE msc_int_src_recommend_detail.planName = PlanIdVar

Line 433: -- TO_NUMBER(substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1))

429: -- TO_NUMBER(substr(msc_int_src_recommend_detail.item_code,instr(msc_int_src_recommend_detail.item_code,':',1,1)+1)),
430: --source_organization_id
431: -- TO_NUMBER(substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )),
432: ---source_org_instance_id
433: -- TO_NUMBER(substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1))
434: --FROM msc_int_src_recommend_detail
435: --WHERE msc_int_src_recommend_detail.planName = PlanIdVar
436: --GROUP BY msc_int_src_recommend_detail.planName,
437: -- msc_int_src_recommend_detail.origin_code,

Line 434: --FROM msc_int_src_recommend_detail

430: --source_organization_id
431: -- TO_NUMBER(substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )),
432: ---source_org_instance_id
433: -- TO_NUMBER(substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1))
434: --FROM msc_int_src_recommend_detail
435: --WHERE msc_int_src_recommend_detail.planName = PlanIdVar
436: --GROUP BY msc_int_src_recommend_detail.planName,
437: -- msc_int_src_recommend_detail.origin_code,
438: -- msc_int_src_recommend_detail.destination_code,

Line 435: --WHERE msc_int_src_recommend_detail.planName = PlanIdVar

431: -- TO_NUMBER(substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )),
432: ---source_org_instance_id
433: -- TO_NUMBER(substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1))
434: --FROM msc_int_src_recommend_detail
435: --WHERE msc_int_src_recommend_detail.planName = PlanIdVar
436: --GROUP BY msc_int_src_recommend_detail.planName,
437: -- msc_int_src_recommend_detail.origin_code,
438: -- msc_int_src_recommend_detail.destination_code,
439: -- msc_int_src_recommend_detail.item_code;

Line 436: --GROUP BY msc_int_src_recommend_detail.planName,

432: ---source_org_instance_id
433: -- TO_NUMBER(substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1))
434: --FROM msc_int_src_recommend_detail
435: --WHERE msc_int_src_recommend_detail.planName = PlanIdVar
436: --GROUP BY msc_int_src_recommend_detail.planName,
437: -- msc_int_src_recommend_detail.origin_code,
438: -- msc_int_src_recommend_detail.destination_code,
439: -- msc_int_src_recommend_detail.item_code;
440: --EXCEPTION WHEN others THEN

Line 437: -- msc_int_src_recommend_detail.origin_code,

433: -- TO_NUMBER(substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1))
434: --FROM msc_int_src_recommend_detail
435: --WHERE msc_int_src_recommend_detail.planName = PlanIdVar
436: --GROUP BY msc_int_src_recommend_detail.planName,
437: -- msc_int_src_recommend_detail.origin_code,
438: -- msc_int_src_recommend_detail.destination_code,
439: -- msc_int_src_recommend_detail.item_code;
440: --EXCEPTION WHEN others THEN
441: --g_ErrorCode := 'ERROR_UPDATE_MSC_SYSTEM_ITEMS_001001' || ' : ' || SQLERRM;

Line 438: -- msc_int_src_recommend_detail.destination_code,

434: --FROM msc_int_src_recommend_detail
435: --WHERE msc_int_src_recommend_detail.planName = PlanIdVar
436: --GROUP BY msc_int_src_recommend_detail.planName,
437: -- msc_int_src_recommend_detail.origin_code,
438: -- msc_int_src_recommend_detail.destination_code,
439: -- msc_int_src_recommend_detail.item_code;
440: --EXCEPTION WHEN others THEN
441: --g_ErrorCode := 'ERROR_UPDATE_MSC_SYSTEM_ITEMS_001001' || ' : ' || SQLERRM;
442: --raise;

Line 439: -- msc_int_src_recommend_detail.item_code;

435: --WHERE msc_int_src_recommend_detail.planName = PlanIdVar
436: --GROUP BY msc_int_src_recommend_detail.planName,
437: -- msc_int_src_recommend_detail.origin_code,
438: -- msc_int_src_recommend_detail.destination_code,
439: -- msc_int_src_recommend_detail.item_code;
440: --EXCEPTION WHEN others THEN
441: --g_ErrorCode := 'ERROR_UPDATE_MSC_SYSTEM_ITEMS_001001' || ' : ' || SQLERRM;
442: --raise;
443: --END;

Line 2310: -- SELECT DISTINCT msc_int_src_recommend_detail.item_code,

2306:
2307: -- 1. SourceItem
2308: --BEGIN
2309: -- INSERT into msc_int_source1 ( item_code, branch_code )
2310: -- SELECT DISTINCT msc_int_src_recommend_detail.item_code,
2311: -- msc_int_src_recommend_detail.destination_code
2312: -- FROM msc_int_src_recommend_detail
2313: -- WHERE msc_int_src_recommend_detail.available = 'Yes';
2314: --EXCEPTION WHEN others THEN

Line 2311: -- msc_int_src_recommend_detail.destination_code

2307: -- 1. SourceItem
2308: --BEGIN
2309: -- INSERT into msc_int_source1 ( item_code, branch_code )
2310: -- SELECT DISTINCT msc_int_src_recommend_detail.item_code,
2311: -- msc_int_src_recommend_detail.destination_code
2312: -- FROM msc_int_src_recommend_detail
2313: -- WHERE msc_int_src_recommend_detail.available = 'Yes';
2314: --EXCEPTION WHEN others THEN
2315: -- g_ErrorCode := 'ERROR_INSERT_msc_int_source1_001021' || ' : ' || SQLERRM;

Line 2312: -- FROM msc_int_src_recommend_detail

2308: --BEGIN
2309: -- INSERT into msc_int_source1 ( item_code, branch_code )
2310: -- SELECT DISTINCT msc_int_src_recommend_detail.item_code,
2311: -- msc_int_src_recommend_detail.destination_code
2312: -- FROM msc_int_src_recommend_detail
2313: -- WHERE msc_int_src_recommend_detail.available = 'Yes';
2314: --EXCEPTION WHEN others THEN
2315: -- g_ErrorCode := 'ERROR_INSERT_msc_int_source1_001021' || ' : ' || SQLERRM;
2316: -- raise;

Line 2313: -- WHERE msc_int_src_recommend_detail.available = 'Yes';

2309: -- INSERT into msc_int_source1 ( item_code, branch_code )
2310: -- SELECT DISTINCT msc_int_src_recommend_detail.item_code,
2311: -- msc_int_src_recommend_detail.destination_code
2312: -- FROM msc_int_src_recommend_detail
2313: -- WHERE msc_int_src_recommend_detail.available = 'Yes';
2314: --EXCEPTION WHEN others THEN
2315: -- g_ErrorCode := 'ERROR_INSERT_msc_int_source1_001021' || ' : ' || SQLERRM;
2316: -- raise;
2317: --END;

Line 2322: -- SELECT DISTINCT msc_int_src_recommend_detail.item_code,

2318:
2319: -- 2. SourceItemBranch
2320: --BEGIN
2321: -- INSERT into msc_int_source2 ( item_code, branch_code, enable_date, disable_date )
2322: -- SELECT DISTINCT msc_int_src_recommend_detail.item_code,
2323: -- msc_int_src_recommend_detail.destination_code,
2324: -- TO_DATE(msc_int_src_recommend_detail.start_date, 'YYYY-MM-DD'),
2325: -- TO_DATE(msc_int_src_recommend_detail.end_date, 'YYYY-MM-DD')
2326: -- FROM msc_int_src_recommend_detail

Line 2323: -- msc_int_src_recommend_detail.destination_code,

2319: -- 2. SourceItemBranch
2320: --BEGIN
2321: -- INSERT into msc_int_source2 ( item_code, branch_code, enable_date, disable_date )
2322: -- SELECT DISTINCT msc_int_src_recommend_detail.item_code,
2323: -- msc_int_src_recommend_detail.destination_code,
2324: -- TO_DATE(msc_int_src_recommend_detail.start_date, 'YYYY-MM-DD'),
2325: -- TO_DATE(msc_int_src_recommend_detail.end_date, 'YYYY-MM-DD')
2326: -- FROM msc_int_src_recommend_detail
2327: -- WHERE msc_int_src_recommend_detail.available = 'Yes';

Line 2324: -- TO_DATE(msc_int_src_recommend_detail.start_date, 'YYYY-MM-DD'),

2320: --BEGIN
2321: -- INSERT into msc_int_source2 ( item_code, branch_code, enable_date, disable_date )
2322: -- SELECT DISTINCT msc_int_src_recommend_detail.item_code,
2323: -- msc_int_src_recommend_detail.destination_code,
2324: -- TO_DATE(msc_int_src_recommend_detail.start_date, 'YYYY-MM-DD'),
2325: -- TO_DATE(msc_int_src_recommend_detail.end_date, 'YYYY-MM-DD')
2326: -- FROM msc_int_src_recommend_detail
2327: -- WHERE msc_int_src_recommend_detail.available = 'Yes';
2328: --EXCEPTION WHEN others THEN

Line 2325: -- TO_DATE(msc_int_src_recommend_detail.end_date, 'YYYY-MM-DD')

2321: -- INSERT into msc_int_source2 ( item_code, branch_code, enable_date, disable_date )
2322: -- SELECT DISTINCT msc_int_src_recommend_detail.item_code,
2323: -- msc_int_src_recommend_detail.destination_code,
2324: -- TO_DATE(msc_int_src_recommend_detail.start_date, 'YYYY-MM-DD'),
2325: -- TO_DATE(msc_int_src_recommend_detail.end_date, 'YYYY-MM-DD')
2326: -- FROM msc_int_src_recommend_detail
2327: -- WHERE msc_int_src_recommend_detail.available = 'Yes';
2328: --EXCEPTION WHEN others THEN
2329: -- g_ErrorCode := 'ERROR_INSERT_msc_int_source2_001022' || ' : ' || SQLERRM;

Line 2326: -- FROM msc_int_src_recommend_detail

2322: -- SELECT DISTINCT msc_int_src_recommend_detail.item_code,
2323: -- msc_int_src_recommend_detail.destination_code,
2324: -- TO_DATE(msc_int_src_recommend_detail.start_date, 'YYYY-MM-DD'),
2325: -- TO_DATE(msc_int_src_recommend_detail.end_date, 'YYYY-MM-DD')
2326: -- FROM msc_int_src_recommend_detail
2327: -- WHERE msc_int_src_recommend_detail.available = 'Yes';
2328: --EXCEPTION WHEN others THEN
2329: -- g_ErrorCode := 'ERROR_INSERT_msc_int_source2_001022' || ' : ' || SQLERRM;
2330: -- raise;

Line 2327: -- WHERE msc_int_src_recommend_detail.available = 'Yes';

2323: -- msc_int_src_recommend_detail.destination_code,
2324: -- TO_DATE(msc_int_src_recommend_detail.start_date, 'YYYY-MM-DD'),
2325: -- TO_DATE(msc_int_src_recommend_detail.end_date, 'YYYY-MM-DD')
2326: -- FROM msc_int_src_recommend_detail
2327: -- WHERE msc_int_src_recommend_detail.available = 'Yes';
2328: --EXCEPTION WHEN others THEN
2329: -- g_ErrorCode := 'ERROR_INSERT_msc_int_source2_001022' || ' : ' || SQLERRM;
2330: -- raise;
2331: --END;

Line 2343: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001001' || ' : ' || SQLERRM;

2339: -- ( select MSC_SR_RECEIPT_ORG.SR_RECEIPT_ID from MSC_SR_ASSIGNMENTS, MSC_SR_RECEIPT_ORG
2340: -- where MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar and
2341: -- MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID = MSC_SR_RECEIPT_ORG.SOURCING_RULE_ID );
2342: -- EXCEPTION WHEN others THEN
2343: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001001' || ' : ' || SQLERRM;
2344: -- NULL;
2345: --END;
2346:
2347: -- 4. clear msc_sr_receipt_org

Line 2355: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001002' || ' : ' || SQLERRM;

2351: -- MSC_SR_RECEIPT_ORG.SOURCING_RULE_ID in
2352: -- ( select MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID from MSC_SR_ASSIGNMENTS
2353: -- where MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar );
2354: -- EXCEPTION WHEN others THEN
2355: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001002' || ' : ' || SQLERRM;
2356: -- NULL;
2357: --END;
2358:
2359: -- 5. clear msc_sourcing_rules

Line 2367: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001003' || ' : ' || SQLERRM;

2363: -- MSC_SOURCING_RULES.SOURCING_RULE_ID in
2364: -- ( select MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID from MSC_SR_ASSIGNMENTS
2365: -- where MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar );
2366: --EXCEPTION WHEN others THEN
2367: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001003' || ' : ' || SQLERRM;
2368: -- NULL;
2369: --END;
2370:
2371: -- 6. clear msc_sr_assignments

Line 2377: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001004' || ' : ' || SQLERRM;

2373: --DELETE from MSC_SR_ASSIGNMENTS
2374: -- WHERE
2375: --MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar;
2376: --EXCEPTION WHEN others THEN
2377: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001004' || ' : ' || SQLERRM;
2378: -- NULL;
2379: --END;
2380:
2381: -- 7. clear msc_item_sourcing

Line 2386: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001005' || ' : ' || SQLERRM;

2382: BEGIN
2383: DELETE from MSC_ITEM_SOURCING
2384: WHERE MSC_ITEM_SOURCING.PLAN_ID = PlanIdVar;
2385: EXCEPTION WHEN others THEN
2386: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001005' || ' : ' || SQLERRM;
2387: NULL;
2388: END;
2389:
2390: -- 8. Insert into MSC_SR_ASSIGNMENTS

Line 2424: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001006' || ' : ' || SQLERRM;

2420: -- sysdate,
2421: -- '-1'
2422: -- FROM msc_int_source1;
2423: -- EXCEPTION WHEN others THEN
2424: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001006' || ' : ' || SQLERRM;
2425: -- raise;
2426: --END;
2427:
2428: -- 9. INSERT into MSC_SOURCING_RULES

Line 2470: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001007' || ' : ' || SQLERRM;

2466: -- MSC_PLAN_ORGANIZATIONS.PLAN_ID = planIdVar and
2467: -- MSC_PLAN_ORGANIZATIONS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and
2468: -- MSC_PLAN_ORGANIZATIONS.ORGANIZATION_ID = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID;
2469: -- EXCEPTION WHEN others THEN
2470: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001007' || ' : ' || SQLERRM;
2471: -- raise;
2472: --END;
2473:
2474: -- 10. INSERT into MSC_SR_RECEIPT_ORG

Line 2513: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001008' || ' : ' || SQLERRM;

2509: -- MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar and
2510: -- MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID || ':' || MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = msc_int_source2.item_code and
2511: -- MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID || ':' || MSC_SR_ASSIGNMENTS.ORGANIZATION_ID = msc_int_source2.branch_code;
2512: -- EXCEPTION WHEN others THEN
2513: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001008' || ' : ' || SQLERRM;
2514: -- raise;
2515: --END;
2516:
2517: -- 11. INSERT into MSC_SR_SOURCE_ORG

Line 2541: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'

2537: -- SELECT
2538: -- MSC_SR_SOURCE_ORG_S.NEXTVAL,
2539: -- -1 * MSC_SR_SOURCE_ORG_S.NEXTVAL,
2540: -- MSC_SR_RECEIPT_ORG.SR_RECEIPT_ID,
2541: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2542: -- then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)
2543: -- else NULL
2544: -- end,
2545: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'

Line 2542: -- then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)

2538: -- MSC_SR_SOURCE_ORG_S.NEXTVAL,
2539: -- -1 * MSC_SR_SOURCE_ORG_S.NEXTVAL,
2540: -- MSC_SR_RECEIPT_ORG.SR_RECEIPT_ID,
2541: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2542: -- then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)
2543: -- else NULL
2544: -- end,
2545: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2546: -- then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )

Line 2545: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'

2541: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2542: -- then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)
2543: -- else NULL
2544: -- end,
2545: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2546: -- then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )
2547: -- else NULL
2548: -- end,
2549: -- MSC_SR_RECEIPT_ORG.SR_INSTANCE_ID,

Line 2546: -- then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )

2542: -- then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)
2543: -- else NULL
2544: -- end,
2545: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2546: -- then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )
2547: -- else NULL
2548: -- end,
2549: -- MSC_SR_RECEIPT_ORG.SR_INSTANCE_ID,
2550: -- case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'

Line 2550: -- case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'

2546: -- then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )
2547: -- else NULL
2548: -- end,
2549: -- MSC_SR_RECEIPT_ORG.SR_INSTANCE_ID,
2550: -- case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2551: -- then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )
2552: -- else NULL
2553: -- end,
2554: -- case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'

Line 2551: -- then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )

2547: -- else NULL
2548: -- end,
2549: -- MSC_SR_RECEIPT_ORG.SR_INSTANCE_ID,
2550: -- case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2551: -- then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )
2552: -- else NULL
2553: -- end,
2554: -- case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2555: -- then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)

Line 2554: -- case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'

2550: -- case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2551: -- then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )
2552: -- else NULL
2553: -- end,
2554: -- case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2555: -- then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)
2556: -- else NULL
2557: -- end,
2558: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal'

Line 2555: -- then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)

2551: -- then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )
2552: -- else NULL
2553: -- end,
2554: -- case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2555: -- then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)
2556: -- else NULL
2557: -- end,
2558: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal'
2559: -- then MSC_INT_SRC_RECOMMEND_DETAIL.transport_mode_code

Line 2558: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal'

2554: -- case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2555: -- then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)
2556: -- else NULL
2557: -- end,
2558: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal'
2559: -- then MSC_INT_SRC_RECOMMEND_DETAIL.transport_mode_code
2560: -- end,
2561: -- NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),
2562: -- MSC_INT_SRC_RECOMMEND_DETAIL.preference,

Line 2559: -- then MSC_INT_SRC_RECOMMEND_DETAIL.transport_mode_code

2555: -- then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)
2556: -- else NULL
2557: -- end,
2558: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal'
2559: -- then MSC_INT_SRC_RECOMMEND_DETAIL.transport_mode_code
2560: -- end,
2561: -- NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),
2562: -- MSC_INT_SRC_RECOMMEND_DETAIL.preference,
2563: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal' then 1

Line 2561: -- NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),

2557: -- end,
2558: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal'
2559: -- then MSC_INT_SRC_RECOMMEND_DETAIL.transport_mode_code
2560: -- end,
2561: -- NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),
2562: -- MSC_INT_SRC_RECOMMEND_DETAIL.preference,
2563: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal' then 1
2564: -- when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Manufactured' then 2
2565: -- when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier' then 3

Line 2562: -- MSC_INT_SRC_RECOMMEND_DETAIL.preference,

2558: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal'
2559: -- then MSC_INT_SRC_RECOMMEND_DETAIL.transport_mode_code
2560: -- end,
2561: -- NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),
2562: -- MSC_INT_SRC_RECOMMEND_DETAIL.preference,
2563: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal' then 1
2564: -- when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Manufactured' then 2
2565: -- when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier' then 3
2566: -- else 1

Line 2563: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal' then 1

2559: -- then MSC_INT_SRC_RECOMMEND_DETAIL.transport_mode_code
2560: -- end,
2561: -- NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),
2562: -- MSC_INT_SRC_RECOMMEND_DETAIL.preference,
2563: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal' then 1
2564: -- when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Manufactured' then 2
2565: -- when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier' then 3
2566: -- else 1
2567: -- end,

Line 2564: -- when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Manufactured' then 2

2560: -- end,
2561: -- NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),
2562: -- MSC_INT_SRC_RECOMMEND_DETAIL.preference,
2563: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal' then 1
2564: -- when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Manufactured' then 2
2565: -- when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier' then 3
2566: -- else 1
2567: -- end,
2568: -- sysdate,

Line 2565: -- when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier' then 3

2561: -- NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),
2562: -- MSC_INT_SRC_RECOMMEND_DETAIL.preference,
2563: -- case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal' then 1
2564: -- when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Manufactured' then 2
2565: -- when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier' then 3
2566: -- else 1
2567: -- end,
2568: -- sysdate,
2569: -- '-1',

Line 2572: -- FROM MSC_SR_ASSIGNMENTS, MSC_SR_RECEIPT_ORG, MSC_INT_SRC_RECOMMEND_DETAIL

2568: -- sysdate,
2569: -- '-1',
2570: -- sysdate,
2571: -- '-1'
2572: -- FROM MSC_SR_ASSIGNMENTS, MSC_SR_RECEIPT_ORG, MSC_INT_SRC_RECOMMEND_DETAIL
2573: -- WHERE MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar
2574: -- AND MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID = MSC_SR_RECEIPT_ORG.SOURCING_RULE_ID
2575: -- AND MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID
2576: -- AND MSC_SR_RECEIPT_ORG.RECEIPT_ORG_INSTANCE_ID || ':' || MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_INT_SRC_RECOMMEND_DETAIL.destination_code

Line 2576: -- AND MSC_SR_RECEIPT_ORG.RECEIPT_ORG_INSTANCE_ID || ':' || MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_INT_SRC_RECOMMEND_DETAIL.destination_code

2572: -- FROM MSC_SR_ASSIGNMENTS, MSC_SR_RECEIPT_ORG, MSC_INT_SRC_RECOMMEND_DETAIL
2573: -- WHERE MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar
2574: -- AND MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID = MSC_SR_RECEIPT_ORG.SOURCING_RULE_ID
2575: -- AND MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID
2576: -- AND MSC_SR_RECEIPT_ORG.RECEIPT_ORG_INSTANCE_ID || ':' || MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_INT_SRC_RECOMMEND_DETAIL.destination_code
2577: -- AND MSC_SR_RECEIPT_ORG.EFFECTIVE_DATE = TO_DATE( MSC_INT_SRC_RECOMMEND_DETAIL.start_date, 'YYYY-MM-DD' )
2578: -- AND MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = substr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,instr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,':',1)+1)
2579: -- AND MSC_INT_SRC_RECOMMEND_DETAIL.available = 'Yes';
2580: -- EXCEPTION WHEN others THEN

Line 2577: -- AND MSC_SR_RECEIPT_ORG.EFFECTIVE_DATE = TO_DATE( MSC_INT_SRC_RECOMMEND_DETAIL.start_date, 'YYYY-MM-DD' )

2573: -- WHERE MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar
2574: -- AND MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID = MSC_SR_RECEIPT_ORG.SOURCING_RULE_ID
2575: -- AND MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID
2576: -- AND MSC_SR_RECEIPT_ORG.RECEIPT_ORG_INSTANCE_ID || ':' || MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_INT_SRC_RECOMMEND_DETAIL.destination_code
2577: -- AND MSC_SR_RECEIPT_ORG.EFFECTIVE_DATE = TO_DATE( MSC_INT_SRC_RECOMMEND_DETAIL.start_date, 'YYYY-MM-DD' )
2578: -- AND MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = substr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,instr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,':',1)+1)
2579: -- AND MSC_INT_SRC_RECOMMEND_DETAIL.available = 'Yes';
2580: -- EXCEPTION WHEN others THEN
2581: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001009' || ' : ' || SQLERRM;

Line 2578: -- AND MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = substr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,instr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,':',1)+1)

2574: -- AND MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID = MSC_SR_RECEIPT_ORG.SOURCING_RULE_ID
2575: -- AND MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID
2576: -- AND MSC_SR_RECEIPT_ORG.RECEIPT_ORG_INSTANCE_ID || ':' || MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_INT_SRC_RECOMMEND_DETAIL.destination_code
2577: -- AND MSC_SR_RECEIPT_ORG.EFFECTIVE_DATE = TO_DATE( MSC_INT_SRC_RECOMMEND_DETAIL.start_date, 'YYYY-MM-DD' )
2578: -- AND MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = substr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,instr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,':',1)+1)
2579: -- AND MSC_INT_SRC_RECOMMEND_DETAIL.available = 'Yes';
2580: -- EXCEPTION WHEN others THEN
2581: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001009' || ' : ' || SQLERRM;
2582: -- raise;

Line 2579: -- AND MSC_INT_SRC_RECOMMEND_DETAIL.available = 'Yes';

2575: -- AND MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID
2576: -- AND MSC_SR_RECEIPT_ORG.RECEIPT_ORG_INSTANCE_ID || ':' || MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_INT_SRC_RECOMMEND_DETAIL.destination_code
2577: -- AND MSC_SR_RECEIPT_ORG.EFFECTIVE_DATE = TO_DATE( MSC_INT_SRC_RECOMMEND_DETAIL.start_date, 'YYYY-MM-DD' )
2578: -- AND MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = substr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,instr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,':',1)+1)
2579: -- AND MSC_INT_SRC_RECOMMEND_DETAIL.available = 'Yes';
2580: -- EXCEPTION WHEN others THEN
2581: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001009' || ' : ' || SQLERRM;
2582: -- raise;
2583: --END;

Line 2581: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001009' || ' : ' || SQLERRM;

2577: -- AND MSC_SR_RECEIPT_ORG.EFFECTIVE_DATE = TO_DATE( MSC_INT_SRC_RECOMMEND_DETAIL.start_date, 'YYYY-MM-DD' )
2578: -- AND MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = substr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,instr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,':',1)+1)
2579: -- AND MSC_INT_SRC_RECOMMEND_DETAIL.available = 'Yes';
2580: -- EXCEPTION WHEN others THEN
2581: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001009' || ' : ' || SQLERRM;
2582: -- raise;
2583: --END;
2584:
2585: -- 12. INSERT into MSC_ITEM_SOURCING for item source count

Line 2638: TO_DATE((select start_date from msc_int_src_recommend_detail where rownum=1), 'YYYY-MM-DD'),

2634: TO_NUMBER(substr(origin_code,instr(origin_code,':',1,1)+1))
2635: END,
2636: TO_NUMBER(substr(item_code,instr(item_code,':',1,1)+1)),
2637: -- Effective date is string type in temp table
2638: TO_DATE((select start_date from msc_int_src_recommend_detail where rownum=1), 'YYYY-MM-DD'),
2639: -23453,
2640: assignmentSetOutIdVar,
2641: -23453,
2642: -23453,

Line 2693: FROM msc_int_src_recommend_detail

2689: sysdate,
2690: -1,
2691: sysdate,
2692: -1
2693: FROM msc_int_src_recommend_detail
2694: WHERE planName = PlanIdVar
2695: GROUP BY planName, origin_code, destination_code,
2696: item_code, sourcing_type, transport_mode_code;
2697: EXCEPTION WHEN others THEN

Line 2698: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001010' || ' : ' || SQLERRM;

2694: WHERE planName = PlanIdVar
2695: GROUP BY planName, origin_code, destination_code,
2696: item_code, sourcing_type, transport_mode_code;
2697: EXCEPTION WHEN others THEN
2698: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001010' || ' : ' || SQLERRM;
2699: raise;
2700: END;
2701:
2702: Status := 'SUCCESS';