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 396: -- delete records from MSC_SYSTEM_ITEMS table for the given PlanId, if any

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

Line 398: DELETE FROM MSC_SYSTEM_ITEMS WHERE PLAN_ID=PlanIdVar;

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

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

401: END;
402:
403: BEGIN
404: -- CODE GOES HERE
405: -- duplicate system items needed in the msc_system_items table with changed PlanId
406: INSERT INTO MSC_SYSTEM_ITEMS (
407: PLAN_ID,
408: ORGANIZATION_ID,
409: INVENTORY_ITEM_ID,

Line 406: INSERT INTO MSC_SYSTEM_ITEMS (

402:
403: BEGIN
404: -- CODE GOES HERE
405: -- duplicate system items needed in the msc_system_items table with changed PlanId
406: INSERT INTO MSC_SYSTEM_ITEMS (
407: PLAN_ID,
408: ORGANIZATION_ID,
409: INVENTORY_ITEM_ID,
410: SR_INSTANCE_ID,

Line 767: FROM MSC_SYSTEM_ITEMS LEFT JOIN MSC_INT_ASCP_INVENTORY ON

763: '-1',
764: -- last update login :
765: -- we do not have the userId here ( no validation should be done at this point as required earlier) :
766: '-1'
767: FROM MSC_SYSTEM_ITEMS LEFT JOIN MSC_INT_ASCP_INVENTORY ON
768: MSC_INT_ASCP_INVENTORY.OrganizationID = MSC_SYSTEM_ITEMS.ORGANIZATION_ID AND
769: MSC_INT_ASCP_INVENTORY.InstanceID = MSC_SYSTEM_ITEMS.SR_INSTANCE_ID AND
770: MSC_INT_ASCP_INVENTORY.ItemId = MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID
771: WHERE MSC_SYSTEM_ITEMS.PLAN_ID=-1 AND MSC_INT_ASCP_INVENTORY.PLAN_ID=PlanIdVar;

Line 768: MSC_INT_ASCP_INVENTORY.OrganizationID = MSC_SYSTEM_ITEMS.ORGANIZATION_ID AND

764: -- last update login :
765: -- we do not have the userId here ( no validation should be done at this point as required earlier) :
766: '-1'
767: FROM MSC_SYSTEM_ITEMS LEFT JOIN MSC_INT_ASCP_INVENTORY ON
768: MSC_INT_ASCP_INVENTORY.OrganizationID = MSC_SYSTEM_ITEMS.ORGANIZATION_ID AND
769: MSC_INT_ASCP_INVENTORY.InstanceID = MSC_SYSTEM_ITEMS.SR_INSTANCE_ID AND
770: MSC_INT_ASCP_INVENTORY.ItemId = MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID
771: WHERE MSC_SYSTEM_ITEMS.PLAN_ID=-1 AND MSC_INT_ASCP_INVENTORY.PLAN_ID=PlanIdVar;
772: EXCEPTION WHEN others THEN

Line 769: MSC_INT_ASCP_INVENTORY.InstanceID = MSC_SYSTEM_ITEMS.SR_INSTANCE_ID AND

765: -- we do not have the userId here ( no validation should be done at this point as required earlier) :
766: '-1'
767: FROM MSC_SYSTEM_ITEMS LEFT JOIN MSC_INT_ASCP_INVENTORY ON
768: MSC_INT_ASCP_INVENTORY.OrganizationID = MSC_SYSTEM_ITEMS.ORGANIZATION_ID AND
769: MSC_INT_ASCP_INVENTORY.InstanceID = MSC_SYSTEM_ITEMS.SR_INSTANCE_ID AND
770: MSC_INT_ASCP_INVENTORY.ItemId = MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID
771: WHERE MSC_SYSTEM_ITEMS.PLAN_ID=-1 AND MSC_INT_ASCP_INVENTORY.PLAN_ID=PlanIdVar;
772: EXCEPTION WHEN others THEN
773: g_ErrorCode := 'ERROR_UPDATE_MSC_SYSTEM_ITEMS_001001';

Line 770: MSC_INT_ASCP_INVENTORY.ItemId = MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID

766: '-1'
767: FROM MSC_SYSTEM_ITEMS LEFT JOIN MSC_INT_ASCP_INVENTORY ON
768: MSC_INT_ASCP_INVENTORY.OrganizationID = MSC_SYSTEM_ITEMS.ORGANIZATION_ID AND
769: MSC_INT_ASCP_INVENTORY.InstanceID = MSC_SYSTEM_ITEMS.SR_INSTANCE_ID AND
770: MSC_INT_ASCP_INVENTORY.ItemId = MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID
771: WHERE MSC_SYSTEM_ITEMS.PLAN_ID=-1 AND MSC_INT_ASCP_INVENTORY.PLAN_ID=PlanIdVar;
772: EXCEPTION WHEN others THEN
773: g_ErrorCode := 'ERROR_UPDATE_MSC_SYSTEM_ITEMS_001001';
774: raise;

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

767: FROM MSC_SYSTEM_ITEMS LEFT JOIN MSC_INT_ASCP_INVENTORY ON
768: MSC_INT_ASCP_INVENTORY.OrganizationID = MSC_SYSTEM_ITEMS.ORGANIZATION_ID AND
769: MSC_INT_ASCP_INVENTORY.InstanceID = MSC_SYSTEM_ITEMS.SR_INSTANCE_ID AND
770: MSC_INT_ASCP_INVENTORY.ItemId = MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID
771: WHERE MSC_SYSTEM_ITEMS.PLAN_ID=-1 AND MSC_INT_ASCP_INVENTORY.PLAN_ID=PlanIdVar;
772: EXCEPTION WHEN others THEN
773: g_ErrorCode := 'ERROR_UPDATE_MSC_SYSTEM_ITEMS_001001';
774: raise;
775: END;

Line 773: g_ErrorCode := 'ERROR_UPDATE_MSC_SYSTEM_ITEMS_001001';

769: MSC_INT_ASCP_INVENTORY.InstanceID = MSC_SYSTEM_ITEMS.SR_INSTANCE_ID AND
770: MSC_INT_ASCP_INVENTORY.ItemId = MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID
771: WHERE MSC_SYSTEM_ITEMS.PLAN_ID=-1 AND MSC_INT_ASCP_INVENTORY.PLAN_ID=PlanIdVar;
772: EXCEPTION WHEN others THEN
773: g_ErrorCode := 'ERROR_UPDATE_MSC_SYSTEM_ITEMS_001001';
774: raise;
775: END;
776:
777:

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

2070: MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID,
2071: -1 * MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID,
2072: MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID, -- // I suppose these are the same.
2073: MSC_SR_ASSIGNMENTS.ORGANIZATION_ID,
2074: (MSC_ASSIGNMENT_SETS.ASSIGNMENT_SET_NAME || ':' || MSC_SYSTEM_ITEMS.ITEM_NAME || ':' || MSC_PLAN_ORGANIZATIONS.ORGANIZATION_CODE),
2075: 1, -- // STATUS
2076: 1, -- // 1 means sourcing rule type
2077: 1,
2078: sysdate,

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

2079: '-1',
2080: sysdate,
2081: '-1',
2082: '2'
2083: FROM MSC_SR_ASSIGNMENTS , MSC_ASSIGNMENT_SETS , MSC_SYSTEM_ITEMS , MSC_PLAN_ORGANIZATIONS -- ( alias org )
2084: WHERE
2085: MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar and
2086: MSC_ASSIGNMENT_SETS.ASSIGNMENT_SET_ID = MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID and
2087: MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and

Line 2087: MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and

2083: FROM MSC_SR_ASSIGNMENTS , MSC_ASSIGNMENT_SETS , MSC_SYSTEM_ITEMS , MSC_PLAN_ORGANIZATIONS -- ( alias org )
2084: WHERE
2085: MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar and
2086: MSC_ASSIGNMENT_SETS.ASSIGNMENT_SET_ID = MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID and
2087: MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and
2088: MSC_SYSTEM_ITEMS.ORGANIZATION_ID = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID and
2089: MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID = MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID and
2090: MSC_SYSTEM_ITEMS.PLAN_ID = -1 and
2091: MSC_PLAN_ORGANIZATIONS.PLAN_ID = planIdVar and

Line 2088: MSC_SYSTEM_ITEMS.ORGANIZATION_ID = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID and

2084: WHERE
2085: MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar and
2086: MSC_ASSIGNMENT_SETS.ASSIGNMENT_SET_ID = MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID and
2087: MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and
2088: MSC_SYSTEM_ITEMS.ORGANIZATION_ID = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID and
2089: MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID = MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID and
2090: MSC_SYSTEM_ITEMS.PLAN_ID = -1 and
2091: MSC_PLAN_ORGANIZATIONS.PLAN_ID = planIdVar and
2092: MSC_PLAN_ORGANIZATIONS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and

Line 2089: MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID = MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID and

2085: MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar and
2086: MSC_ASSIGNMENT_SETS.ASSIGNMENT_SET_ID = MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID and
2087: MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and
2088: MSC_SYSTEM_ITEMS.ORGANIZATION_ID = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID and
2089: MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID = MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID and
2090: MSC_SYSTEM_ITEMS.PLAN_ID = -1 and
2091: MSC_PLAN_ORGANIZATIONS.PLAN_ID = planIdVar and
2092: MSC_PLAN_ORGANIZATIONS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and
2093: MSC_PLAN_ORGANIZATIONS.ORGANIZATION_ID = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID;

Line 2090: MSC_SYSTEM_ITEMS.PLAN_ID = -1 and

2086: MSC_ASSIGNMENT_SETS.ASSIGNMENT_SET_ID = MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID and
2087: MSC_SYSTEM_ITEMS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and
2088: MSC_SYSTEM_ITEMS.ORGANIZATION_ID = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID and
2089: MSC_SYSTEM_ITEMS.INVENTORY_ITEM_ID = MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID and
2090: MSC_SYSTEM_ITEMS.PLAN_ID = -1 and
2091: MSC_PLAN_ORGANIZATIONS.PLAN_ID = planIdVar and
2092: MSC_PLAN_ORGANIZATIONS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and
2093: MSC_PLAN_ORGANIZATIONS.ORGANIZATION_ID = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID;
2094: EXCEPTION WHEN others THEN