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_BIS_INV_DETAIL

Line 1732: -- delete records from MSC_BIS_INV_DETAIL table for the given PlanId, if any

1728: raise;
1729: END;
1730:
1731:
1732: -- delete records from MSC_BIS_INV_DETAIL table for the given PlanId, if any
1733: BEGIN
1734: DELETE FROM MSC_BIS_INV_DETAIL WHERE PLAN_ID=PlanIdVar;
1735: EXCEPTION WHEN others THEN
1736: NULL; -- do nothing

Line 1734: DELETE FROM MSC_BIS_INV_DETAIL WHERE PLAN_ID=PlanIdVar;

1730:
1731:
1732: -- delete records from MSC_BIS_INV_DETAIL table for the given PlanId, if any
1733: BEGIN
1734: DELETE FROM MSC_BIS_INV_DETAIL WHERE PLAN_ID=PlanIdVar;
1735: EXCEPTION WHEN others THEN
1736: NULL; -- do nothing
1737: END;
1738:

Line 1809: -- final table: MSC_BIS_INV_DETAIL

1805: g_ErrorCode := 'ERROR_UPDATE_BIS_INV_DETAIL_001006' || ' : ' || SQLERRM;
1806: raise;
1807: END;
1808:
1809: -- final table: MSC_BIS_INV_DETAIL
1810:
1811: ----------------------------------------
1812: -- Purchasing cost
1813: ----------------------------------------

Line 1816: INSERT INTO MSC_BIS_INV_DETAIL (PLAN_ID,

1812: -- Purchasing cost
1813: ----------------------------------------
1814: BEGIN
1815: -- CODE GOES HERE
1816: INSERT INTO MSC_BIS_INV_DETAIL (PLAN_ID,
1817: ORGANIZATION_ID,
1818: SR_INSTANCE_ID,
1819: INVENTORY_ITEM_ID,
1820: DETAIL_LEVEL,

Line 1896: INSERT INTO MSC_BIS_INV_DETAIL (PLAN_ID,

1892: -- Transportation cost + Contrained Forecast
1893: ----------------------------------------
1894: BEGIN
1895: -- CODE GOES HERE
1896: INSERT INTO MSC_BIS_INV_DETAIL (PLAN_ID,
1897: ORGANIZATION_ID,
1898: SR_INSTANCE_ID,
1899: INVENTORY_ITEM_ID,
1900: DETAIL_LEVEL,

Line 2036: INSERT INTO MSC_BIS_INV_DETAIL (PLAN_ID,

2032: BEGIN
2033: --------------------------------
2034: -- Supplier-independent records ( Revenue, Production, Carry and Other costs )
2035: --------------------------------
2036: INSERT INTO MSC_BIS_INV_DETAIL (PLAN_ID,
2037: ORGANIZATION_ID,
2038: SR_INSTANCE_ID,
2039: INVENTORY_ITEM_ID,
2040: DETAIL_LEVEL,

Line 2147: INSERT INTO MSC_BIS_INV_DETAIL (PLAN_ID,

2143: -- as msc_int_ascp_kpi, so we insert ditectly
2144: -- from total prod cost
2145: ----------------------------------------------
2146: BEGIN
2147: INSERT INTO MSC_BIS_INV_DETAIL (PLAN_ID,
2148: ORGANIZATION_ID,
2149: SR_INSTANCE_ID,
2150: INVENTORY_ITEM_ID,
2151: DETAIL_LEVEL,

Line 2223: INSERT INTO MSC_BIS_INV_DETAIL (PLAN_ID,

2219: -- ItemTravelDistance records
2220: --------------------------------
2221: BEGIN
2222: -- CODE GOES HERE
2223: INSERT INTO MSC_BIS_INV_DETAIL (PLAN_ID,
2224: ORGANIZATION_ID,
2225: SR_INSTANCE_ID,
2226: INVENTORY_ITEM_ID,
2227: DETAIL_LEVEL,