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_SUPPLY

Line 1073: -- Fill in data from MSC_INT_ASCP_SUPPLY

1069:
1070: BEGIN
1071: -- CODE GOES HERE
1072: --
1073: -- Fill in data from MSC_INT_ASCP_SUPPLY
1074: --
1075: INSERT INTO MSC_SUPPLIES (PLAN_ID,
1076: TRANSACTION_ID,
1077: ORGANIZATION_ID,

Line 1095: FROM MSC_INT_ASCP_SUPPLY

1091: instanceID, itemID, 1, TO_DATE(PeriodEnd,'YYYY-MM-DD')-1/86400,
1092: supply, 2, SupplierID,
1093: supplierSiteID,
1094: SYSDATE, '-1', SYSDATE, '-1'
1095: FROM MSC_INT_ASCP_SUPPLY
1096: WHERE PLAN_ID=PlanIdVar AND MSC_INT_ASCP_SUPPLY.CATEGORY='Supply';
1097:
1098: -- NOTE: Last four fields: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY are non-NULL,
1099: -- so I harcoded an arbitrary value

Line 1096: WHERE PLAN_ID=PlanIdVar AND MSC_INT_ASCP_SUPPLY.CATEGORY='Supply';

1092: supply, 2, SupplierID,
1093: supplierSiteID,
1094: SYSDATE, '-1', SYSDATE, '-1'
1095: FROM MSC_INT_ASCP_SUPPLY
1096: WHERE PLAN_ID=PlanIdVar AND MSC_INT_ASCP_SUPPLY.CATEGORY='Supply';
1097:
1098: -- NOTE: Last four fields: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY are non-NULL,
1099: -- so I harcoded an arbitrary value
1100: EXCEPTION WHEN others THEN

Line 1101: g_ErrorCode := 'ERROR_UPDATE_SUPPLIES_FROM_MSC_INT_ASCP_SUPPLY_001001';

1097:
1098: -- NOTE: Last four fields: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY are non-NULL,
1099: -- so I harcoded an arbitrary value
1100: EXCEPTION WHEN others THEN
1101: g_ErrorCode := 'ERROR_UPDATE_SUPPLIES_FROM_MSC_INT_ASCP_SUPPLY_001001';
1102: raise;
1103: END;
1104:
1105: BEGIN

Line 1721: case when MSC_INT_ASCP_SUPPLY.COST * MSC_INT_ASCP_SUPPLY.SUPPLY is

1717: 0, --TO_NUMBER(NULL) MDS_PRICE,
1718: TO_NUMBER(NULL), -- ZONEID,
1719: 0, --TO_NUMBER(NULL) PRODUCTION_COST,
1720: -- supplier related column: purchase cost
1721: case when MSC_INT_ASCP_SUPPLY.COST * MSC_INT_ASCP_SUPPLY.SUPPLY is
1722: null then 0
1723: else MSC_INT_ASCP_SUPPLY.COST * MSC_INT_ASCP_SUPPLY.SUPPLY end,
1724: 0,--TO_NUMBER(NULL) CARRYING_COST,
1725: 0,--TO_NUMBER(NULL) TRANSPORTATION_COST,

Line 1723: else MSC_INT_ASCP_SUPPLY.COST * MSC_INT_ASCP_SUPPLY.SUPPLY end,

1719: 0, --TO_NUMBER(NULL) PRODUCTION_COST,
1720: -- supplier related column: purchase cost
1721: case when MSC_INT_ASCP_SUPPLY.COST * MSC_INT_ASCP_SUPPLY.SUPPLY is
1722: null then 0
1723: else MSC_INT_ASCP_SUPPLY.COST * MSC_INT_ASCP_SUPPLY.SUPPLY end,
1724: 0,--TO_NUMBER(NULL) CARRYING_COST,
1725: 0,--TO_NUMBER(NULL) TRANSPORTATION_COST,
1726: 0,--TO_NUMBER(NULL) OTHER_COST,
1727: 0,--TO_NUMBER(NULL) PAB,

Line 1733: MSC_INT_ASCP_SUPPLY.SupplierID,

1729: 0,--TO_NUMBER(NULL) SERVICE_LEVEL_1,
1730: 0,--TO_NUMBER(NULL) SERVICE_LEVEL_2,
1731: null,--TO_CHAR(NULL) SHIP_METHOD,
1732: -- supplier related columns
1733: MSC_INT_ASCP_SUPPLY.SupplierID,
1734: MSC_INT_ASCP_SUPPLY.SupplierSiteID,
1735: MSC_INT_ASCP_SUPPLY.SUPPLY,
1736: MSC_INT_ASCP_SUPPLY.CAPACITY,
1737: 0,--TO_NUMBER(NULL) MDS_QUANTITY,

Line 1734: MSC_INT_ASCP_SUPPLY.SupplierSiteID,

1730: 0,--TO_NUMBER(NULL) SERVICE_LEVEL_2,
1731: null,--TO_CHAR(NULL) SHIP_METHOD,
1732: -- supplier related columns
1733: MSC_INT_ASCP_SUPPLY.SupplierID,
1734: MSC_INT_ASCP_SUPPLY.SupplierSiteID,
1735: MSC_INT_ASCP_SUPPLY.SUPPLY,
1736: MSC_INT_ASCP_SUPPLY.CAPACITY,
1737: 0,--TO_NUMBER(NULL) MDS_QUANTITY,
1738: 0,--TO_NUMBER(NULL) INVENTORY_QUANTITY,

Line 1735: MSC_INT_ASCP_SUPPLY.SUPPLY,

1731: null,--TO_CHAR(NULL) SHIP_METHOD,
1732: -- supplier related columns
1733: MSC_INT_ASCP_SUPPLY.SupplierID,
1734: MSC_INT_ASCP_SUPPLY.SupplierSiteID,
1735: MSC_INT_ASCP_SUPPLY.SUPPLY,
1736: MSC_INT_ASCP_SUPPLY.CAPACITY,
1737: 0,--TO_NUMBER(NULL) MDS_QUANTITY,
1738: 0,--TO_NUMBER(NULL) INVENTORY_QUANTITY,
1739: SYSDATE, '-1', SYSDATE, '-1'

Line 1736: MSC_INT_ASCP_SUPPLY.CAPACITY,

1732: -- supplier related columns
1733: MSC_INT_ASCP_SUPPLY.SupplierID,
1734: MSC_INT_ASCP_SUPPLY.SupplierSiteID,
1735: MSC_INT_ASCP_SUPPLY.SUPPLY,
1736: MSC_INT_ASCP_SUPPLY.CAPACITY,
1737: 0,--TO_NUMBER(NULL) MDS_QUANTITY,
1738: 0,--TO_NUMBER(NULL) INVENTORY_QUANTITY,
1739: SYSDATE, '-1', SYSDATE, '-1'
1740: FROM MSC_INT_ASCP_KPI, MSC_INT_ASCP_SUPPLY

Line 1740: FROM MSC_INT_ASCP_KPI, MSC_INT_ASCP_SUPPLY

1736: MSC_INT_ASCP_SUPPLY.CAPACITY,
1737: 0,--TO_NUMBER(NULL) MDS_QUANTITY,
1738: 0,--TO_NUMBER(NULL) INVENTORY_QUANTITY,
1739: SYSDATE, '-1', SYSDATE, '-1'
1740: FROM MSC_INT_ASCP_KPI, MSC_INT_ASCP_SUPPLY
1741: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=MSC_INT_ASCP_KPI.PLAN_ID AND
1742: MSC_INT_ASCP_SUPPLY.OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1743: MSC_INT_ASCP_SUPPLY.ItemID=MSC_INT_ASCP_KPI.ItemID AND
1744: MSC_INT_ASCP_SUPPLY.PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

Line 1741: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=MSC_INT_ASCP_KPI.PLAN_ID AND

1737: 0,--TO_NUMBER(NULL) MDS_QUANTITY,
1738: 0,--TO_NUMBER(NULL) INVENTORY_QUANTITY,
1739: SYSDATE, '-1', SYSDATE, '-1'
1740: FROM MSC_INT_ASCP_KPI, MSC_INT_ASCP_SUPPLY
1741: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=MSC_INT_ASCP_KPI.PLAN_ID AND
1742: MSC_INT_ASCP_SUPPLY.OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1743: MSC_INT_ASCP_SUPPLY.ItemID=MSC_INT_ASCP_KPI.ItemID AND
1744: MSC_INT_ASCP_SUPPLY.PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1745: MSC_INT_ASCP_SUPPLY.InstanceID=MSC_INT_ASCP_KPI.InstanceID AND

Line 1742: MSC_INT_ASCP_SUPPLY.OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND

1738: 0,--TO_NUMBER(NULL) INVENTORY_QUANTITY,
1739: SYSDATE, '-1', SYSDATE, '-1'
1740: FROM MSC_INT_ASCP_KPI, MSC_INT_ASCP_SUPPLY
1741: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=MSC_INT_ASCP_KPI.PLAN_ID AND
1742: MSC_INT_ASCP_SUPPLY.OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1743: MSC_INT_ASCP_SUPPLY.ItemID=MSC_INT_ASCP_KPI.ItemID AND
1744: MSC_INT_ASCP_SUPPLY.PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1745: MSC_INT_ASCP_SUPPLY.InstanceID=MSC_INT_ASCP_KPI.InstanceID AND
1746: MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;

Line 1743: MSC_INT_ASCP_SUPPLY.ItemID=MSC_INT_ASCP_KPI.ItemID AND

1739: SYSDATE, '-1', SYSDATE, '-1'
1740: FROM MSC_INT_ASCP_KPI, MSC_INT_ASCP_SUPPLY
1741: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=MSC_INT_ASCP_KPI.PLAN_ID AND
1742: MSC_INT_ASCP_SUPPLY.OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1743: MSC_INT_ASCP_SUPPLY.ItemID=MSC_INT_ASCP_KPI.ItemID AND
1744: MSC_INT_ASCP_SUPPLY.PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1745: MSC_INT_ASCP_SUPPLY.InstanceID=MSC_INT_ASCP_KPI.InstanceID AND
1746: MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;
1747: EXCEPTION WHEN others THEN

Line 1744: MSC_INT_ASCP_SUPPLY.PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

1740: FROM MSC_INT_ASCP_KPI, MSC_INT_ASCP_SUPPLY
1741: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=MSC_INT_ASCP_KPI.PLAN_ID AND
1742: MSC_INT_ASCP_SUPPLY.OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1743: MSC_INT_ASCP_SUPPLY.ItemID=MSC_INT_ASCP_KPI.ItemID AND
1744: MSC_INT_ASCP_SUPPLY.PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1745: MSC_INT_ASCP_SUPPLY.InstanceID=MSC_INT_ASCP_KPI.InstanceID AND
1746: MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;
1747: EXCEPTION WHEN others THEN
1748: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001008';

Line 1745: MSC_INT_ASCP_SUPPLY.InstanceID=MSC_INT_ASCP_KPI.InstanceID AND

1741: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=MSC_INT_ASCP_KPI.PLAN_ID AND
1742: MSC_INT_ASCP_SUPPLY.OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
1743: MSC_INT_ASCP_SUPPLY.ItemID=MSC_INT_ASCP_KPI.ItemID AND
1744: MSC_INT_ASCP_SUPPLY.PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
1745: MSC_INT_ASCP_SUPPLY.InstanceID=MSC_INT_ASCP_KPI.InstanceID AND
1746: MSC_INT_ASCP_KPI.PLAN_ID=PlanIdVar;
1747: EXCEPTION WHEN others THEN
1748: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001008';
1749: raise;