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.CST_MGD_LIFO_COST_PROCESSOR dependencies on CSTGILEV_TEMP

Line 54: --| into cstgilev_temp statements. Bug 5239725 |

50: --| compared to identify the first period |
51: --| 05/24/2006 vmutyala Replaced ORG_ORGANIZATION_DEFINITIONS to avoid |
52: --| performance issue and added the join condition on|
53: --| cost_layer_id between pic and pql in all insert |
54: --| into cstgilev_temp statements. Bug 5239725 |
55: --+==========================================================================*/
56:
57: --=================
58: -- TYPES

Line 916: INSERT into CSTGILEV_TEMP(

912:
913: IF l_market_value IS null
914: THEN
915:
916: INSERT into CSTGILEV_TEMP(
917: item_id
918: , item_desc
919: , period_id
920: , period_name

Line 973: INSERT into CSTGILEV_TEMP(

969: AND pic.cost_layer_id = pql.cost_layer_id;
970:
971: ELSE
972:
973: INSERT into CSTGILEV_TEMP(
974: item_id
975: , item_desc
976: , period_id
977: , period_name

Line 1036: UPDATE CSTGILEV_TEMP

1032: END LOOP;
1033:
1034: -- find the total value of all calculated inventory values
1035:
1036: UPDATE CSTGILEV_TEMP
1037: SET total_inventory_value =
1038: (SELECT SUM(inventory_value)
1039: FROM cstgilev_temp
1040: WHERE period_id = p_pac_period_id)

Line 1039: FROM cstgilev_temp

1035:
1036: UPDATE CSTGILEV_TEMP
1037: SET total_inventory_value =
1038: (SELECT SUM(inventory_value)
1039: FROM cstgilev_temp
1040: WHERE period_id = p_pac_period_id)
1041: WHERE period_id = p_pac_period_id
1042: AND item_id = l_current_item;
1043:

Line 1165: INSERT into CSTGILEV_TEMP(

1161:
1162: IF l_market_value IS NULL
1163: THEN
1164:
1165: INSERT into CSTGILEV_TEMP(
1166: item_id
1167: , item_desc
1168: , period_id
1169: , period_name

Line 1221: INSERT into CSTGILEV_TEMP(

1217:
1218:
1219: ELSE
1220:
1221: INSERT into CSTGILEV_TEMP(
1222: item_id
1223: , item_desc
1224: , period_id
1225: , period_name

Line 1287: INSERT into CSTGILEV_TEMP(

1283:
1284: IF l_market_value IS NULL
1285: THEN
1286:
1287: INSERT into CSTGILEV_TEMP(
1288: item_id
1289: , item_desc
1290: , period_id
1291: , period_name

Line 1346: INSERT into CSTGILEV_TEMP(

1342: AND pic.cost_layer_id = pql.cost_layer_id;
1343:
1344: ELSE
1345:
1346: INSERT into CSTGILEV_TEMP(
1347: item_id
1348: , item_desc
1349: , period_id
1350: , period_name

Line 1411: UPDATE CSTGILEV_TEMP

1407:
1408: -- Only insert one value into total_inventory_value
1409: -- so that the report sums correctly
1410:
1411: UPDATE CSTGILEV_TEMP
1412: SET total_inventory_value =
1413: (SELECT
1414: inventory_value
1415: FROM cstgilev_temp

Line 1415: FROM cstgilev_temp

1411: UPDATE CSTGILEV_TEMP
1412: SET total_inventory_value =
1413: (SELECT
1414: inventory_value
1415: FROM cstgilev_temp
1416: WHERE period_id = p_pac_period_id
1417: AND item_id = l_current_item)
1418: WHERE period_id = p_pac_period_id
1419: AND item_id = l_current_item;

Line 1449: -- the temporary table CSTGILEV_TEMP with summarized

1445: -- : p_item_code_to end of item range
1446: -- : x_retcode 0 success, 1 warning, 2 error
1447: -- : x_errbuff error buffer
1448: -- COMMENT : This Procedure decides whether to populate
1449: -- the temporary table CSTGILEV_TEMP with summarized
1450: -- or detailed information.
1451: -- PRE-COND : The procedure is called from a before report trigger in
1452: -- the incremental LIFO evaluation report. The cost processor
1453: -- has already run.