DBA Data[Home] [Help]

APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_INT_ASCP_TOTALPRODCOST

Line 1725: DELETE FROM msc_int_ascp_totalprodcost; -- where msc_int_ascp_totalprodcost.plan_id=PlanIdVar; --??BUGBUG ??

1721: raise;
1722: END;
1723:
1724: BEGIN
1725: DELETE FROM msc_int_ascp_totalprodcost; -- where msc_int_ascp_totalprodcost.plan_id=PlanIdVar; --??BUGBUG ??
1726: EXCEPTION WHEN others THEN
1727: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001002' || ' : ' || SQLERRM;
1728: raise;
1729: END;

Line 1782: INSERT INTO msc_int_ascp_totalprodcost ( plan_id,

1778: -- fill in data from msc_int_ascp_prodcost_kpi
1779: -- Due to reansporation cost being mvoed out of msc_int_ascp_kpi, the table
1780: -- no longer has corresponding org-item records for heere to compare. But the
1781: -- records are already unique so we directly sum them up.
1782: INSERT INTO msc_int_ascp_totalprodcost ( plan_id,
1783: organizationID,
1784: instanceID,
1785: itemID,
1786: periodEnd,

Line 2085: --case when (SELECT COUNT(*) FROM msc_int_ascp_totalprodcost

2081: MSC_INT_ASCP_KPI.Customer_ID, --CUSTOMER_ID,
2082:
2083: -- production_cost: added as separate records
2084: 0,
2085: --case when (SELECT COUNT(*) FROM msc_int_ascp_totalprodcost
2086: -- WHERE PLAN_ID=PlanIdVar AND
2087: -- OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2088: -- ItemID=MSC_INT_ASCP_KPI.ItemID AND
2089: -- PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

Line 2093: -- msc_int_ascp_totalprodcost

2089: -- PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND
2090: -- InstanceID=MSC_INT_ASCP_KPI.InstanceID
2091: -- )=0 then 0
2092: -- else (SELECT DISTINCT ( totalProdCost ) FROM -- ( BUGBUG Does not accept FIRST )
2093: -- msc_int_ascp_totalprodcost
2094: -- WHERE PLAN_ID=PlanIdVar AND
2095: -- OrganizationID=MSC_INT_ASCP_KPI.OrganizationID AND
2096: -- ItemID=MSC_INT_ASCP_KPI.ItemID AND
2097: -- PERIODEND=MSC_INT_ASCP_KPI.PERIODEND AND

Line 2180: SELECT msc_int_ascp_totalprodcost.PLAN_ID,

2176: LAST_UPDATE_DATE,
2177: LAST_UPDATED_BY,
2178: CREATION_DATE,
2179: CREATED_BY)
2180: SELECT msc_int_ascp_totalprodcost.PLAN_ID,
2181: msc_int_ascp_totalprodcost.OrganizationID,
2182: msc_int_ascp_totalprodcost.InstanceID,
2183: msc_int_ascp_totalprodcost.ItemID,
2184: ( 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 2181: msc_int_ascp_totalprodcost.OrganizationID,

2177: LAST_UPDATED_BY,
2178: CREATION_DATE,
2179: CREATED_BY)
2180: SELECT msc_int_ascp_totalprodcost.PLAN_ID,
2181: msc_int_ascp_totalprodcost.OrganizationID,
2182: msc_int_ascp_totalprodcost.InstanceID,
2183: msc_int_ascp_totalprodcost.ItemID,
2184: ( 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 )
2185: 1,

Line 2182: msc_int_ascp_totalprodcost.InstanceID,

2178: CREATION_DATE,
2179: CREATED_BY)
2180: SELECT msc_int_ascp_totalprodcost.PLAN_ID,
2181: msc_int_ascp_totalprodcost.OrganizationID,
2182: msc_int_ascp_totalprodcost.InstanceID,
2183: msc_int_ascp_totalprodcost.ItemID,
2184: ( 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 )
2185: 1,
2186: TO_DATE( msc_int_ascp_totalprodcost.PeriodEnd,'YYYY-MM-DD' )-1/86400,

Line 2183: msc_int_ascp_totalprodcost.ItemID,

2179: CREATED_BY)
2180: SELECT msc_int_ascp_totalprodcost.PLAN_ID,
2181: msc_int_ascp_totalprodcost.OrganizationID,
2182: msc_int_ascp_totalprodcost.InstanceID,
2183: msc_int_ascp_totalprodcost.ItemID,
2184: ( 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 )
2185: 1,
2186: TO_DATE( msc_int_ascp_totalprodcost.PeriodEnd,'YYYY-MM-DD' )-1/86400,
2187: 0, --TO_NUMBER(NULL) MDS_PRICE,

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

2182: msc_int_ascp_totalprodcost.InstanceID,
2183: msc_int_ascp_totalprodcost.ItemID,
2184: ( 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 )
2185: 1,
2186: TO_DATE( msc_int_ascp_totalprodcost.PeriodEnd,'YYYY-MM-DD' )-1/86400,
2187: 0, --TO_NUMBER(NULL) MDS_PRICE,
2188: -23453, -- ZONEID,
2189:
2190: msc_int_ascp_totalprodcost.totalprodcost,

Line 2190: msc_int_ascp_totalprodcost.totalprodcost,

2186: TO_DATE( msc_int_ascp_totalprodcost.PeriodEnd,'YYYY-MM-DD' )-1/86400,
2187: 0, --TO_NUMBER(NULL) MDS_PRICE,
2188: -23453, -- ZONEID,
2189:
2190: msc_int_ascp_totalprodcost.totalprodcost,
2191: 0, -- purchase cost
2192: 0,--TO_NUMBER(NULL) CARRYING_COST,
2193: 0,--TO_NUMBER(NULL) TRANSPORTATION_COST,
2194: 0,--TO_NUMBER(NULL) OTHER_COST,

Line 2211: FROM msc_int_ascp_totalprodcost

2207: -23453, -- CUSTOMER_ID
2208: 0,--TO_NUMBER(NULL) MDS_QUANTITY,
2209: 0,--TO_NUMBER(NULL) INVENTORY_QUANTITY,
2210: SYSDATE, '-1', SYSDATE, '-1'
2211: FROM msc_int_ascp_totalprodcost
2212: WHERE msc_int_ascp_totalprodcost.PLAN_ID=PlanIdVar;
2213: EXCEPTION WHEN others THEN
2214: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001118' || ' : ' || SQLERRM;
2215: raise;

Line 2212: WHERE msc_int_ascp_totalprodcost.PLAN_ID=PlanIdVar;

2208: 0,--TO_NUMBER(NULL) MDS_QUANTITY,
2209: 0,--TO_NUMBER(NULL) INVENTORY_QUANTITY,
2210: SYSDATE, '-1', SYSDATE, '-1'
2211: FROM msc_int_ascp_totalprodcost
2212: WHERE msc_int_ascp_totalprodcost.PLAN_ID=PlanIdVar;
2213: EXCEPTION WHEN others THEN
2214: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001118' || ' : ' || SQLERRM;
2215: raise;
2216: END;