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_SYSTEM_ITEMS

Line 398: -- delete records from MSC_SYSTEM_ITEMS table for the given PlanId, if any

394: -- init global variables
395: g_ErrorCode := '';
396:
397:
398: -- delete records from MSC_SYSTEM_ITEMS table for the given PlanId, if any
399: BEGIN
400: DELETE FROM MSC_SYSTEM_ITEMS WHERE PLAN_ID=PlanIdVar;
401: EXCEPTION WHEN others THEN
402: NULL; -- do nothing

Line 400: DELETE FROM MSC_SYSTEM_ITEMS WHERE PLAN_ID=PlanIdVar;

396:
397:
398: -- delete records from MSC_SYSTEM_ITEMS table for the given PlanId, if any
399: BEGIN
400: DELETE FROM MSC_SYSTEM_ITEMS WHERE PLAN_ID=PlanIdVar;
401: EXCEPTION WHEN others THEN
402: NULL; -- do nothing
403: END;
404:

Line 441: --g_ErrorCode := 'ERROR_UPDATE_MSC_SYSTEM_ITEMS_001001' || ' : ' || SQLERRM;

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;
444:
445: BEGIN

Line 447: -- duplicate system items needed in the msc_system_items table with changed PlanId

443: --END;
444:
445: BEGIN
446: -- CODE GOES HERE
447: -- duplicate system items needed in the msc_system_items table with changed PlanId
448: INSERT INTO MSC_SYSTEM_ITEMS (
449: PLAN_ID,
450: ORGANIZATION_ID,
451: INVENTORY_ITEM_ID,

Line 448: INSERT INTO MSC_SYSTEM_ITEMS (

444:
445: BEGIN
446: -- CODE GOES HERE
447: -- duplicate system items needed in the msc_system_items table with changed PlanId
448: INSERT INTO MSC_SYSTEM_ITEMS (
449: PLAN_ID,
450: ORGANIZATION_ID,
451: INVENTORY_ITEM_ID,
452: SR_INSTANCE_ID,

Line 807: -- MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_INT_APCC_ITEM_SOURCE.sr_instance_id AND

803: -- number of sources ( new measure )
804: --(select COUNT( DISTINCT MSC_INT_APCC_ITEM_SOURCE.source_organization_id )
805: -- from MSC_INT_APCC_ITEM_SOURCE
806: -- WHERE PlanIdVar = MSC_INT_APCC_ITEM_SOURCE.plan_ID AND
807: -- MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_INT_APCC_ITEM_SOURCE.sr_instance_id AND
808: -- MSC_SYSTEM_ITEMS.ORGANIZATION_ID = MSC_INT_APCC_ITEM_SOURCE.organization_id AND
809: -- MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID = MSC_INT_APCC_ITEM_SOURCE.inventory_item_id
810: -- ), -- must specify table name before columns to avoid duplicate count
811: SYSDATE,

Line 808: -- MSC_SYSTEM_ITEMS.ORGANIZATION_ID = MSC_INT_APCC_ITEM_SOURCE.organization_id AND

804: --(select COUNT( DISTINCT MSC_INT_APCC_ITEM_SOURCE.source_organization_id )
805: -- from MSC_INT_APCC_ITEM_SOURCE
806: -- WHERE PlanIdVar = MSC_INT_APCC_ITEM_SOURCE.plan_ID AND
807: -- MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_INT_APCC_ITEM_SOURCE.sr_instance_id AND
808: -- MSC_SYSTEM_ITEMS.ORGANIZATION_ID = MSC_INT_APCC_ITEM_SOURCE.organization_id AND
809: -- MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID = MSC_INT_APCC_ITEM_SOURCE.inventory_item_id
810: -- ), -- must specify table name before columns to avoid duplicate count
811: SYSDATE,
812: '-1',

Line 809: -- MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID = MSC_INT_APCC_ITEM_SOURCE.inventory_item_id

805: -- from MSC_INT_APCC_ITEM_SOURCE
806: -- WHERE PlanIdVar = MSC_INT_APCC_ITEM_SOURCE.plan_ID AND
807: -- MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_INT_APCC_ITEM_SOURCE.sr_instance_id AND
808: -- MSC_SYSTEM_ITEMS.ORGANIZATION_ID = MSC_INT_APCC_ITEM_SOURCE.organization_id AND
809: -- MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID = MSC_INT_APCC_ITEM_SOURCE.inventory_item_id
810: -- ), -- must specify table name before columns to avoid duplicate count
811: SYSDATE,
812: '-1',
813: SYSDATE,

Line 818: FROM MSC_SYSTEM_ITEMS LEFT JOIN MSC_INT_ASCP_INVENTORY ON

814: '-1',
815: -- last update login :
816: -- we do not have the userId here ( no validation should be done at this point as required earlier) :
817: '-1'
818: FROM MSC_SYSTEM_ITEMS LEFT JOIN MSC_INT_ASCP_INVENTORY ON
819: MSC_INT_ASCP_INVENTORY.OrganizationID = MSC_SYSTEM_ITEMS.ORGANIZATION_ID AND
820: MSC_INT_ASCP_INVENTORY.InstanceID = MSC_SYSTEM_ITEMS.SR_INSTANCE_ID AND
821: MSC_INT_ASCP_INVENTORY.ItemId = MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID
822: WHERE MSC_SYSTEM_ITEMS.PLAN_ID=-1 AND MSC_INT_ASCP_INVENTORY.PLAN_ID=PlanIdVar;

Line 819: MSC_INT_ASCP_INVENTORY.OrganizationID = MSC_SYSTEM_ITEMS.ORGANIZATION_ID AND

815: -- last update login :
816: -- we do not have the userId here ( no validation should be done at this point as required earlier) :
817: '-1'
818: FROM MSC_SYSTEM_ITEMS LEFT JOIN MSC_INT_ASCP_INVENTORY ON
819: MSC_INT_ASCP_INVENTORY.OrganizationID = MSC_SYSTEM_ITEMS.ORGANIZATION_ID AND
820: MSC_INT_ASCP_INVENTORY.InstanceID = MSC_SYSTEM_ITEMS.SR_INSTANCE_ID AND
821: MSC_INT_ASCP_INVENTORY.ItemId = MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID
822: WHERE MSC_SYSTEM_ITEMS.PLAN_ID=-1 AND MSC_INT_ASCP_INVENTORY.PLAN_ID=PlanIdVar;
823: EXCEPTION WHEN others THEN

Line 820: MSC_INT_ASCP_INVENTORY.InstanceID = MSC_SYSTEM_ITEMS.SR_INSTANCE_ID AND

816: -- we do not have the userId here ( no validation should be done at this point as required earlier) :
817: '-1'
818: FROM MSC_SYSTEM_ITEMS LEFT JOIN MSC_INT_ASCP_INVENTORY ON
819: MSC_INT_ASCP_INVENTORY.OrganizationID = MSC_SYSTEM_ITEMS.ORGANIZATION_ID AND
820: MSC_INT_ASCP_INVENTORY.InstanceID = MSC_SYSTEM_ITEMS.SR_INSTANCE_ID AND
821: MSC_INT_ASCP_INVENTORY.ItemId = MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID
822: WHERE MSC_SYSTEM_ITEMS.PLAN_ID=-1 AND MSC_INT_ASCP_INVENTORY.PLAN_ID=PlanIdVar;
823: EXCEPTION WHEN others THEN
824: g_ErrorCode := 'ERROR_UPDATE_MSC_SYSTEM_ITEMS_001002' || ' : ' || SQLERRM;

Line 821: MSC_INT_ASCP_INVENTORY.ItemId = MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID

817: '-1'
818: FROM MSC_SYSTEM_ITEMS LEFT JOIN MSC_INT_ASCP_INVENTORY ON
819: MSC_INT_ASCP_INVENTORY.OrganizationID = MSC_SYSTEM_ITEMS.ORGANIZATION_ID AND
820: MSC_INT_ASCP_INVENTORY.InstanceID = MSC_SYSTEM_ITEMS.SR_INSTANCE_ID AND
821: MSC_INT_ASCP_INVENTORY.ItemId = MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID
822: WHERE MSC_SYSTEM_ITEMS.PLAN_ID=-1 AND MSC_INT_ASCP_INVENTORY.PLAN_ID=PlanIdVar;
823: EXCEPTION WHEN others THEN
824: g_ErrorCode := 'ERROR_UPDATE_MSC_SYSTEM_ITEMS_001002' || ' : ' || SQLERRM;
825: raise;

Line 822: WHERE MSC_SYSTEM_ITEMS.PLAN_ID=-1 AND MSC_INT_ASCP_INVENTORY.PLAN_ID=PlanIdVar;

818: FROM MSC_SYSTEM_ITEMS LEFT JOIN MSC_INT_ASCP_INVENTORY ON
819: MSC_INT_ASCP_INVENTORY.OrganizationID = MSC_SYSTEM_ITEMS.ORGANIZATION_ID AND
820: MSC_INT_ASCP_INVENTORY.InstanceID = MSC_SYSTEM_ITEMS.SR_INSTANCE_ID AND
821: MSC_INT_ASCP_INVENTORY.ItemId = MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID
822: WHERE MSC_SYSTEM_ITEMS.PLAN_ID=-1 AND MSC_INT_ASCP_INVENTORY.PLAN_ID=PlanIdVar;
823: EXCEPTION WHEN others THEN
824: g_ErrorCode := 'ERROR_UPDATE_MSC_SYSTEM_ITEMS_001002' || ' : ' || SQLERRM;
825: raise;
826: END;

Line 824: g_ErrorCode := 'ERROR_UPDATE_MSC_SYSTEM_ITEMS_001002' || ' : ' || SQLERRM;

820: MSC_INT_ASCP_INVENTORY.InstanceID = MSC_SYSTEM_ITEMS.SR_INSTANCE_ID AND
821: MSC_INT_ASCP_INVENTORY.ItemId = MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID
822: WHERE MSC_SYSTEM_ITEMS.PLAN_ID=-1 AND MSC_INT_ASCP_INVENTORY.PLAN_ID=PlanIdVar;
823: EXCEPTION WHEN others THEN
824: g_ErrorCode := 'ERROR_UPDATE_MSC_SYSTEM_ITEMS_001002' || ' : ' || SQLERRM;
825: raise;
826: END;
827:
828: COMMIT; -- BUGBUG SHould this be -- checkpoint commit INSTEAD

Line 2449: -- (MSC_ASSIGNMENT_SETS.ASSIGNMENT_SET_NAME || ':' || MSC_SYSTEM_ITEMS.ITEM_NAME || ':' || MSC_PLAN_ORGANIZATIONS.ORGANIZATION_CODE),

2445: -- MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID,
2446: -- -1 * MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID,
2447: -- MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID, -- // I suppose these are the same.
2448: -- MSC_SR_ASSIGNMENTS.ORGANIZATION_ID,
2449: -- (MSC_ASSIGNMENT_SETS.ASSIGNMENT_SET_NAME || ':' || MSC_SYSTEM_ITEMS.ITEM_NAME || ':' || MSC_PLAN_ORGANIZATIONS.ORGANIZATION_CODE),
2450: -- 1, -- // STATUS
2451: -- 1, -- // 1 means sourcing rule type
2452: -- 1,
2453: -- sysdate,

Line 2458: -- FROM MSC_SR_ASSIGNMENTS , MSC_ASSIGNMENT_SETS , MSC_SYSTEM_ITEMS , MSC_PLAN_ORGANIZATIONS -- ( alias org )

2454: -- '-1',
2455: -- sysdate,
2456: -- '-1',
2457: -- '2'
2458: -- FROM MSC_SR_ASSIGNMENTS , MSC_ASSIGNMENT_SETS , MSC_SYSTEM_ITEMS , MSC_PLAN_ORGANIZATIONS -- ( alias org )
2459: -- WHERE
2460: -- MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar and
2461: -- MSC_ASSIGNMENT_SETS.ASSIGNMENT_SET_ID = MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID and
2462: -- MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and

Line 2462: -- MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and

2458: -- FROM MSC_SR_ASSIGNMENTS , MSC_ASSIGNMENT_SETS , MSC_SYSTEM_ITEMS , MSC_PLAN_ORGANIZATIONS -- ( alias org )
2459: -- WHERE
2460: -- MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar and
2461: -- MSC_ASSIGNMENT_SETS.ASSIGNMENT_SET_ID = MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID and
2462: -- MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and
2463: -- MSC_SYSTEM_ITEMS.ORGANIZATION_ID = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID and
2464: -- MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID = MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID and
2465: -- MSC_SYSTEM_ITEMS.PLAN_ID = -1 and
2466: -- MSC_PLAN_ORGANIZATIONS.PLAN_ID = planIdVar and

Line 2463: -- MSC_SYSTEM_ITEMS.ORGANIZATION_ID = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID and

2459: -- WHERE
2460: -- MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar and
2461: -- MSC_ASSIGNMENT_SETS.ASSIGNMENT_SET_ID = MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID and
2462: -- MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and
2463: -- MSC_SYSTEM_ITEMS.ORGANIZATION_ID = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID and
2464: -- MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID = MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID and
2465: -- MSC_SYSTEM_ITEMS.PLAN_ID = -1 and
2466: -- MSC_PLAN_ORGANIZATIONS.PLAN_ID = planIdVar and
2467: -- MSC_PLAN_ORGANIZATIONS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and

Line 2464: -- MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID = MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID and

2460: -- MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar and
2461: -- MSC_ASSIGNMENT_SETS.ASSIGNMENT_SET_ID = MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID and
2462: -- MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and
2463: -- MSC_SYSTEM_ITEMS.ORGANIZATION_ID = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID and
2464: -- MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID = MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID and
2465: -- MSC_SYSTEM_ITEMS.PLAN_ID = -1 and
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;

Line 2465: -- MSC_SYSTEM_ITEMS.PLAN_ID = -1 and

2461: -- MSC_ASSIGNMENT_SETS.ASSIGNMENT_SET_ID = MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID and
2462: -- MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and
2463: -- MSC_SYSTEM_ITEMS.ORGANIZATION_ID = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID and
2464: -- MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID = MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID and
2465: -- MSC_SYSTEM_ITEMS.PLAN_ID = -1 and
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