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.OPI_EDW_IDS_CALC dependencies on CST_STANDARD_COSTS

Line 952: -- the CST_STANDARD_COSTS table. This stores the latest

948: cost_date IN DATE)
949: RETURN NUMBER
950: IS
951: -- Cursor for cost query. This returns the newest cost from
952: -- the CST_STANDARD_COSTS table. This stores the latest
953: -- cost, except for new items.
954: CURSOR cost_on_date_csr (org_id NUMBER, item_id NUMBER,
955: cost_date DATE)
956: IS

Line 958: FROM CST_STANDARD_COSTS csc

954: CURSOR cost_on_date_csr (org_id NUMBER, item_id NUMBER,
955: cost_date DATE)
956: IS
957: SELECT csc.standard_cost unit_cost -- Standard cost method logic.
958: FROM CST_STANDARD_COSTS csc
959: WHERE csc.ORGANIZATION_ID = org_id
960: AND csc.INVENTORY_ITEM_ID = item_id
961: AND csc.STANDARD_COST_REVISION_DATE =
962: (SELECT max(csc2.STANDARD_COST_REVISION_DATE)

Line 963: FROM CST_STANDARD_COSTS csc2

959: WHERE csc.ORGANIZATION_ID = org_id
960: AND csc.INVENTORY_ITEM_ID = item_id
961: AND csc.STANDARD_COST_REVISION_DATE =
962: (SELECT max(csc2.STANDARD_COST_REVISION_DATE)
963: FROM CST_STANDARD_COSTS csc2
964: WHERE csc2.ORGANIZATION_ID = org_id
965: AND csc2.INVENTORY_ITEM_ID = item_id
966: AND csc2.STANDARD_COST_REVISION_DATE <
967: trunc(cost_date) + 1 );