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_ASCP_INVENTORY

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 1256: -- Fill in data from MSC_INT_ASCP_INVENTORY

1252:
1253: BEGIN
1254: -- CODE GOES HERE
1255: --
1256: -- Fill in data from MSC_INT_ASCP_INVENTORY
1257: --
1258: INSERT INTO MSC_SUPPLIES (PLAN_ID,
1259: TRANSACTION_ID,
1260: ORGANIZATION_ID,

Line 1274: FROM MSC_INT_ASCP_INVENTORY

1270: CREATED_BY)
1271: SELECT PlanIdVar, msc_supplies_s.nextval, organizationId, instanceId,
1272: itemID, 18, TO_DATE(PeriodEnd,'YYYY-MM-DD')-1/86400, onHand, 2,
1273: SYSDATE, '-1', SYSDATE, '-1'
1274: FROM MSC_INT_ASCP_INVENTORY
1275: WHERE PLAN_ID=PlanIdVar AND MSC_INT_ASCP_INVENTORY.CATEGORY='Inventory';
1276: EXCEPTION WHEN others THEN
1277: g_ErrorCode := 'ERROR_UPDATE_SUPPLIES_FROM_MSC_INT_ASCP_INVENTORY_001003' || ' : ' || SQLERRM;
1278: raise;

Line 1275: WHERE PLAN_ID=PlanIdVar AND MSC_INT_ASCP_INVENTORY.CATEGORY='Inventory';

1271: SELECT PlanIdVar, msc_supplies_s.nextval, organizationId, instanceId,
1272: itemID, 18, TO_DATE(PeriodEnd,'YYYY-MM-DD')-1/86400, onHand, 2,
1273: SYSDATE, '-1', SYSDATE, '-1'
1274: FROM MSC_INT_ASCP_INVENTORY
1275: WHERE PLAN_ID=PlanIdVar AND MSC_INT_ASCP_INVENTORY.CATEGORY='Inventory';
1276: EXCEPTION WHEN others THEN
1277: g_ErrorCode := 'ERROR_UPDATE_SUPPLIES_FROM_MSC_INT_ASCP_INVENTORY_001003' || ' : ' || SQLERRM;
1278: raise;
1279: END;

Line 1277: g_ErrorCode := 'ERROR_UPDATE_SUPPLIES_FROM_MSC_INT_ASCP_INVENTORY_001003' || ' : ' || SQLERRM;

1273: SYSDATE, '-1', SYSDATE, '-1'
1274: FROM MSC_INT_ASCP_INVENTORY
1275: WHERE PLAN_ID=PlanIdVar AND MSC_INT_ASCP_INVENTORY.CATEGORY='Inventory';
1276: EXCEPTION WHEN others THEN
1277: g_ErrorCode := 'ERROR_UPDATE_SUPPLIES_FROM_MSC_INT_ASCP_INVENTORY_001003' || ' : ' || SQLERRM;
1278: raise;
1279: END;
1280:
1281: BEGIN

Line 1368: FROM MSC_INT_ASCP_INVENTORY

1364: SELECT PlanIdVar, OrganizationID, InstanceID,
1365: ItemID, TO_DATE(Period,'YYYY-MM-DD'), Safety,
1366: ROWNUM, --BUGBUG this value is in, just to make index unique
1367: SYSDATE, '-1', SYSDATE, '-1'
1368: FROM MSC_INT_ASCP_INVENTORY
1369: WHERE PLAN_ID=PlanIdVar;
1370: -- NOTE: Last four fields: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY are non-NULL,
1371: -- so I harcoded an arbitrary value
1372: EXCEPTION WHEN others THEN

Line 2107: case when (SELECT COUNT(*) FROM MSC_INT_ASCP_INVENTORY

2103:
2104: -- other cost
2105: MSC_INT_ASCP_KPI.OtherCost,
2106: -- PAB
2107: case when (SELECT COUNT(*) FROM MSC_INT_ASCP_INVENTORY
2108: WHERE PLAN_ID=PlanIdVar AND
2109: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2110: ItemID=MSC_INT_ASCP_KPI.ItemID AND
2111: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

Line 2114: else (SELECT DISTINCT ( StorageAmount ) FROM MSC_INT_ASCP_INVENTORY -- ( BUGBUG Does not accept FIRST )

2110: ItemID=MSC_INT_ASCP_KPI.ItemID AND
2111: PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2112: InstanceID=MSC_INT_ASCP_KPI.InstanceID
2113: )=0 then 0
2114: else (SELECT DISTINCT ( StorageAmount ) FROM MSC_INT_ASCP_INVENTORY -- ( BUGBUG Does not accept FIRST )
2115: WHERE
2116: PLAN_ID=PlanIdVar AND
2117: OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2118: ItemID=MSC_INT_ASCP_KPI.ItemID AND

Line 3208: -- ... then clear the records from MSC_INT_ASCP_INVENTORY table for the given PlanIdVar if any

3204: EXCEPTION WHEN others THEN
3205: NULL; -- do nothing
3206: END;
3207:
3208: -- ... then clear the records from MSC_INT_ASCP_INVENTORY table for the given PlanIdVar if any
3209: BEGIN
3210: DELETE FROM MSC_INT_ASCP_INVENTORY WHERE PLAN_ID=PlanIdVar;
3211: EXCEPTION WHEN others THEN
3212: NULL; -- do nothing

Line 3210: DELETE FROM MSC_INT_ASCP_INVENTORY WHERE PLAN_ID=PlanIdVar;

3206: END;
3207:
3208: -- ... then clear the records from MSC_INT_ASCP_INVENTORY table for the given PlanIdVar if any
3209: BEGIN
3210: DELETE FROM MSC_INT_ASCP_INVENTORY WHERE PLAN_ID=PlanIdVar;
3211: EXCEPTION WHEN others THEN
3212: NULL; -- do nothing
3213: END;
3214: