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 1176: -- Fill in data from MSC_INT_ASCP_SUPPLY

1172:
1173: BEGIN
1174: -- CODE GOES HERE
1175: --
1176: -- Fill in data from MSC_INT_ASCP_SUPPLY
1177: --
1178: INSERT INTO MSC_SUPPLIES (PLAN_ID,
1179: TRANSACTION_ID,
1180: ORGANIZATION_ID,

Line 1198: FROM MSC_INT_ASCP_SUPPLY

1194: instanceID, itemID, 1, TO_DATE(PeriodEnd,'YYYY-MM-DD')-1/86400,
1195: supply, 2, SupplierID,
1196: supplierSiteID,
1197: SYSDATE, '-1', SYSDATE, '-1'
1198: FROM MSC_INT_ASCP_SUPPLY
1199: WHERE PLAN_ID=PlanIdVar AND MSC_INT_ASCP_SUPPLY.CATEGORY='Supply';
1200:
1201: -- NOTE: Last four fields: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY are non-NULL,
1202: -- so I harcoded an arbitrary value

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

1195: supply, 2, SupplierID,
1196: supplierSiteID,
1197: SYSDATE, '-1', SYSDATE, '-1'
1198: FROM MSC_INT_ASCP_SUPPLY
1199: WHERE PLAN_ID=PlanIdVar AND MSC_INT_ASCP_SUPPLY.CATEGORY='Supply';
1200:
1201: -- NOTE: Last four fields: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY are non-NULL,
1202: -- so I harcoded an arbitrary value
1203: EXCEPTION WHEN others THEN

Line 1204: g_ErrorCode := 'ERROR_UPDATE_SUPPLIES_FROM_MSC_INT_ASCP_SUPPLY_001001' || ' : ' || SQLERRM;

1200:
1201: -- NOTE: Last four fields: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY are non-NULL,
1202: -- so I harcoded an arbitrary value
1203: EXCEPTION WHEN others THEN
1204: g_ErrorCode := 'ERROR_UPDATE_SUPPLIES_FROM_MSC_INT_ASCP_SUPPLY_001001' || ' : ' || SQLERRM;
1205: raise;
1206: END;
1207:
1208: BEGIN

Line 1852: SELECT MSC_INT_ASCP_SUPPLY.PLAN_ID,

1848: CREATED_BY)
1849: --------------------------------
1850: -- Supplier-dependent records
1851: --------------------------------
1852: SELECT MSC_INT_ASCP_SUPPLY.PLAN_ID,
1853: MSC_INT_ASCP_SUPPLY.OrganizationID,
1854: MSC_INT_ASCP_SUPPLY.InstanceID,
1855: MSC_INT_ASCP_SUPPLY.ItemID,
1856: ( select DISTINCT MSC_INT_ASCP_KPI.PeriodType from MSC_INT_ASCP_KPI where MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar ), -- we do not have it ASCP_Supply report ( BUGBUG does not accept FIRST )

Line 1853: MSC_INT_ASCP_SUPPLY.OrganizationID,

1849: --------------------------------
1850: -- Supplier-dependent records
1851: --------------------------------
1852: SELECT MSC_INT_ASCP_SUPPLY.PLAN_ID,
1853: MSC_INT_ASCP_SUPPLY.OrganizationID,
1854: MSC_INT_ASCP_SUPPLY.InstanceID,
1855: MSC_INT_ASCP_SUPPLY.ItemID,
1856: ( select DISTINCT MSC_INT_ASCP_KPI.PeriodType from MSC_INT_ASCP_KPI where MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar ), -- we do not have it ASCP_Supply report ( BUGBUG does not accept FIRST )
1857: 1,

Line 1854: MSC_INT_ASCP_SUPPLY.InstanceID,

1850: -- Supplier-dependent records
1851: --------------------------------
1852: SELECT MSC_INT_ASCP_SUPPLY.PLAN_ID,
1853: MSC_INT_ASCP_SUPPLY.OrganizationID,
1854: MSC_INT_ASCP_SUPPLY.InstanceID,
1855: MSC_INT_ASCP_SUPPLY.ItemID,
1856: ( select DISTINCT MSC_INT_ASCP_KPI.PeriodType from MSC_INT_ASCP_KPI where MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar ), -- we do not have it ASCP_Supply report ( BUGBUG does not accept FIRST )
1857: 1,
1858: TO_DATE( MSC_INT_ASCP_SUPPLY.PeriodEnd,'YYYY-MM-DD' )-1/86400,

Line 1855: MSC_INT_ASCP_SUPPLY.ItemID,

1851: --------------------------------
1852: SELECT MSC_INT_ASCP_SUPPLY.PLAN_ID,
1853: MSC_INT_ASCP_SUPPLY.OrganizationID,
1854: MSC_INT_ASCP_SUPPLY.InstanceID,
1855: MSC_INT_ASCP_SUPPLY.ItemID,
1856: ( select DISTINCT MSC_INT_ASCP_KPI.PeriodType from MSC_INT_ASCP_KPI where MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar ), -- we do not have it ASCP_Supply report ( BUGBUG does not accept FIRST )
1857: 1,
1858: TO_DATE( MSC_INT_ASCP_SUPPLY.PeriodEnd,'YYYY-MM-DD' )-1/86400,
1859: 0, --TO_NUMBER(NULL) MDS_PRICE,

Line 1858: TO_DATE( MSC_INT_ASCP_SUPPLY.PeriodEnd,'YYYY-MM-DD' )-1/86400,

1854: MSC_INT_ASCP_SUPPLY.InstanceID,
1855: MSC_INT_ASCP_SUPPLY.ItemID,
1856: ( select DISTINCT MSC_INT_ASCP_KPI.PeriodType from MSC_INT_ASCP_KPI where MSC_INT_ASCP_KPI.PLAN_ID = PlanIdVar ), -- we do not have it ASCP_Supply report ( BUGBUG does not accept FIRST )
1857: 1,
1858: TO_DATE( MSC_INT_ASCP_SUPPLY.PeriodEnd,'YYYY-MM-DD' )-1/86400,
1859: 0, --TO_NUMBER(NULL) MDS_PRICE,
1860: -23453, -- ZONEID,
1861: 0, --TO_NUMBER(NULL) PRODUCTION_COST,
1862: -- supplier related column: purchase cost

Line 1863: MSC_INT_ASCP_SUPPLY.COST * MSC_INT_ASCP_SUPPLY.SUPPLY,

1859: 0, --TO_NUMBER(NULL) MDS_PRICE,
1860: -23453, -- ZONEID,
1861: 0, --TO_NUMBER(NULL) PRODUCTION_COST,
1862: -- supplier related column: purchase cost
1863: MSC_INT_ASCP_SUPPLY.COST * MSC_INT_ASCP_SUPPLY.SUPPLY,
1864: 0,--TO_NUMBER(NULL) CARRYING_COST,
1865: 0,--TO_NUMBER(NULL) TRANSPORTATION_COST,
1866: 0,--TO_NUMBER(NULL) OTHER_COST,
1867: 0,--TO_NUMBER(NULL) PAB,

Line 1873: MSC_INT_ASCP_SUPPLY.SupplierID,

1869: 0,--TO_NUMBER(NULL) SERVICE_LEVEL_1,
1870: 0,--TO_NUMBER(NULL) SERVICE_LEVEL_2,
1871: null,--TO_CHAR(NULL) SHIP_METHOD,
1872: -- supplier related columns
1873: MSC_INT_ASCP_SUPPLY.SupplierID,
1874: MSC_INT_ASCP_SUPPLY.SupplierSiteID,
1875: MSC_INT_ASCP_SUPPLY.SUPPLY,
1876: MSC_INT_ASCP_SUPPLY.CAPACITY,
1877: -23453, -- SOURCE_ORG_INSTANCE_ID

Line 1874: MSC_INT_ASCP_SUPPLY.SupplierSiteID,

1870: 0,--TO_NUMBER(NULL) SERVICE_LEVEL_2,
1871: null,--TO_CHAR(NULL) SHIP_METHOD,
1872: -- supplier related columns
1873: MSC_INT_ASCP_SUPPLY.SupplierID,
1874: MSC_INT_ASCP_SUPPLY.SupplierSiteID,
1875: MSC_INT_ASCP_SUPPLY.SUPPLY,
1876: MSC_INT_ASCP_SUPPLY.CAPACITY,
1877: -23453, -- SOURCE_ORG_INSTANCE_ID
1878: -23453, -- SOURCE_ORGANIZATION_ID

Line 1875: MSC_INT_ASCP_SUPPLY.SUPPLY,

1871: null,--TO_CHAR(NULL) SHIP_METHOD,
1872: -- supplier related columns
1873: MSC_INT_ASCP_SUPPLY.SupplierID,
1874: MSC_INT_ASCP_SUPPLY.SupplierSiteID,
1875: MSC_INT_ASCP_SUPPLY.SUPPLY,
1876: MSC_INT_ASCP_SUPPLY.CAPACITY,
1877: -23453, -- SOURCE_ORG_INSTANCE_ID
1878: -23453, -- SOURCE_ORGANIZATION_ID
1879: -23453, -- CUSTOMER_SITE_ID

Line 1876: MSC_INT_ASCP_SUPPLY.CAPACITY,

1872: -- supplier related columns
1873: MSC_INT_ASCP_SUPPLY.SupplierID,
1874: MSC_INT_ASCP_SUPPLY.SupplierSiteID,
1875: MSC_INT_ASCP_SUPPLY.SUPPLY,
1876: MSC_INT_ASCP_SUPPLY.CAPACITY,
1877: -23453, -- SOURCE_ORG_INSTANCE_ID
1878: -23453, -- SOURCE_ORGANIZATION_ID
1879: -23453, -- CUSTOMER_SITE_ID
1880: -23453, -- CUSTOMER_ID

Line 1884: FROM MSC_INT_ASCP_SUPPLY

1880: -23453, -- CUSTOMER_ID
1881: 0,--TO_NUMBER(NULL) MDS_QUANTITY,
1882: 0,--TO_NUMBER(NULL) INVENTORY_QUANTITY,
1883: SYSDATE, '-1', SYSDATE, '-1'
1884: FROM MSC_INT_ASCP_SUPPLY
1885: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=PlanIdVar;
1886: EXCEPTION WHEN others THEN
1887: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001008' || ' : ' || SQLERRM;
1888: raise;

Line 1885: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=PlanIdVar;

1881: 0,--TO_NUMBER(NULL) MDS_QUANTITY,
1882: 0,--TO_NUMBER(NULL) INVENTORY_QUANTITY,
1883: SYSDATE, '-1', SYSDATE, '-1'
1884: FROM MSC_INT_ASCP_SUPPLY
1885: WHERE MSC_INT_ASCP_SUPPLY.PLAN_ID=PlanIdVar;
1886: EXCEPTION WHEN others THEN
1887: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001008' || ' : ' || SQLERRM;
1888: raise;
1889: END;