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 CST_PAC_ITEM_COSTS

Line 118: cst_pac_item_costs

114: SELECT
115: cst_pac_periods.pac_period_id
116: FROM
117: cst_pac_periods,
118: cst_pac_item_costs
119: WHERE cst_pac_periods.pac_period_id = cst_pac_item_costs.pac_period_id
120: AND cst_pac_item_costs.inventory_item_id = p_item_id
121: AND cst_pac_item_costs.cost_group_id = p_cost_group_id
122: AND cst_pac_periods.cost_type_id = p_cost_type_id

Line 119: WHERE cst_pac_periods.pac_period_id = cst_pac_item_costs.pac_period_id

115: cst_pac_periods.pac_period_id
116: FROM
117: cst_pac_periods,
118: cst_pac_item_costs
119: WHERE cst_pac_periods.pac_period_id = cst_pac_item_costs.pac_period_id
120: AND cst_pac_item_costs.inventory_item_id = p_item_id
121: AND cst_pac_item_costs.cost_group_id = p_cost_group_id
122: AND cst_pac_periods.cost_type_id = p_cost_type_id
123: ORDER BY cst_pac_periods.period_year, cst_pac_periods.period_num;

Line 120: AND cst_pac_item_costs.inventory_item_id = p_item_id

116: FROM
117: cst_pac_periods,
118: cst_pac_item_costs
119: WHERE cst_pac_periods.pac_period_id = cst_pac_item_costs.pac_period_id
120: AND cst_pac_item_costs.inventory_item_id = p_item_id
121: AND cst_pac_item_costs.cost_group_id = p_cost_group_id
122: AND cst_pac_periods.cost_type_id = p_cost_type_id
123: ORDER BY cst_pac_periods.period_year, cst_pac_periods.period_num;
124:

Line 121: AND cst_pac_item_costs.cost_group_id = p_cost_group_id

117: cst_pac_periods,
118: cst_pac_item_costs
119: WHERE cst_pac_periods.pac_period_id = cst_pac_item_costs.pac_period_id
120: AND cst_pac_item_costs.inventory_item_id = p_item_id
121: AND cst_pac_item_costs.cost_group_id = p_cost_group_id
122: AND cst_pac_periods.cost_type_id = p_cost_type_id
123: ORDER BY cst_pac_periods.period_year, cst_pac_periods.period_num;
124:
125:

Line 189: cst_pac_item_costs cpic

185: INTO
186: l_begin_quantity
187: ,l_market_value
188: FROM
189: cst_pac_item_costs cpic
190: , cst_pac_quantity_layers cpql
191: WHERE cpic.pac_period_id = l_current_period
192: AND cpic.inventory_item_id = p_item_id
193: AND cpic.cost_group_id = p_cost_group_id

Line 279: cst_pac_item_costs

275: ,nvl(make_quantity,0)
276: ,nvl(issue_quantity,0)
277: ,market_value
278: FROM
279: cst_pac_item_costs
280: WHERE pac_period_id = c_period_id
281: AND cost_group_id = c_cost_group_id
282: AND inventory_item_id = c_inventory_item_id;
283:

Line 324: cst_pac_item_costs

320: INTO
321: l_current_total
322: , l_market_value
323: FROM
324: cst_pac_item_costs
325: WHERE pac_period_id = l_delta_period
326: AND inventory_item_id = p_item_id
327: AND cost_group_id = p_cost_group_id;
328:

Line 390: UPDATE cst_pac_item_costs

386: CLOSE get_quantity_cur;
387:
388: l_current_total := l_previous_total + l_buy_quantity + l_make_quantity - l_issue_quantity;
389:
390: UPDATE cst_pac_item_costs
391: SET
392: last_updated_by = p_user_id
393: ,last_update_date = sysdate
394: ,last_update_login = p_login_id

Line 448: -- CST_PAC_ITEM_COSTS.ITEM_COST with that value.

444: -- : p_cost_group_id cost group id
445: -- : p_cost_type_id cost type id
446: -- : p_user_id user id
447: -- COMMENT : Calculate the Incremental LIFO item cost and populate
448: -- CST_PAC_ITEM_COSTS.ITEM_COST with that value.
449: -- PRE-COND : The delta quantity can be pulled for CST_PAC_QUANTITY_LAYERS.
450: -- The weighted average cost per item per period can be easily
451: -- calculated
452: --=========================================================================

Line 544: cst_pac_item_costs cpic

540: , item_make_cost
541: , inventory_item_id
542: , l_market_value
543: FROM
544: cst_pac_item_costs cpic
545: WHERE cpic.pac_period_id = l_current_period
546: AND cpic.inventory_item_id = p_item_id
547: AND cpic.cost_group_id = p_cost_group_id;
548:

Line 561: cst_pac_item_costs cpic, cst_pac_quantity_layers cpql

557: INTO
558: l_quantity_layers
559: , l_wac_cost
560: FROM
561: cst_pac_item_costs cpic, cst_pac_quantity_layers cpql
562: WHERE cpic.pac_period_id = cpql.pac_period_id
563: AND cpic.cost_group_id = cpql.cost_group_id
564: AND cpic.inventory_item_id = cpql.inventory_item_id
565: AND cpic.pac_period_id = l_current_period

Line 581: cst_pac_item_costs cpic, cst_pac_quantity_layers cpql

577: INTO
578: l_quantity_layers
579: , l_wac_cost
580: FROM
581: cst_pac_item_costs cpic, cst_pac_quantity_layers cpql
582: WHERE cpic.pac_period_id = cpql.pac_period_id
583: AND cpic.cost_group_id = cpql.cost_group_id
584: AND cpic.inventory_item_id = cpql.inventory_item_id
585: AND cpic.pac_period_id = l_current_period

Line 621: FROM cst_pac_item_costs cpic, cst_pac_quantity_layers cpql

617: INTO
618: l_y_quant
619: , l_wac_cost
620: , j_market_value
621: FROM cst_pac_item_costs cpic, cst_pac_quantity_layers cpql
622: WHERE cpic.pac_period_id = cpql.pac_period_id
623: AND cpic.cost_group_id = cpql.cost_group_id
624: AND cpic.inventory_item_id = cpql.inventory_item_id
625: AND cpic.pac_period_id = l_delta_period

Line 659: FROM cst_pac_item_costs

655: SELECT
656: total_layer_quantity
657: INTO
658: l_total_quantity
659: FROM cst_pac_item_costs
660: WHERE pac_period_id = l_current_period
661: AND inventory_item_id = p_item_id
662: AND cost_group_id = p_cost_group_id;
663:

Line 677: FROM cst_pac_item_costs

673: ,justification
674: INTO l_rowid
675: ,l_market_value
676: ,l_justification
677: FROM cst_pac_item_costs
678: WHERE pac_period_id = l_current_period
679: AND inventory_item_id = p_item_id
680: AND cost_group_id = p_cost_group_id;
681:

Line 686: CST_PAC_ITEM_COSTS_PKG.update_row( l_rowid_char

682: l_rowid_char := ROWIDTOCHAR(l_rowid);
683:
684: -- Call the table handler to update item cost
685:
686: CST_PAC_ITEM_COSTS_PKG.update_row( l_rowid_char
687: , l_lifo_cost
688: , l_market_value
689: , l_justification
690: , sysdate

Line 725: -- PRE-COND : The weighted average cost recorded in CST_PAC_ITEM_COSTS

721: -- COMMENT : Gateway procedure to the three procedures that calcualate
722: -- incremental LIFO. Called from the pac worker after
723: -- transactional processing and loops through all inventory
724: -- items for a particular period.
725: -- PRE-COND : The weighted average cost recorded in CST_PAC_ITEM_COSTS
726: -- for the period must be solely for items bought or made in
727: -- that period.
728: --=========================================================================
729: PROCEDURE lifo_cost_processor

Line 752: cst_pac_item_costs

748: CURSOR item_cur IS
749: SELECT
750: inventory_item_id
751: FROM
752: cst_pac_item_costs
753: WHERE pac_period_id = p_pac_period_id
754: AND cost_group_id = p_cost_group_id;
755:
756: --=================

Line 865: cst_pac_item_costs

861: CURSOR item_cur IS
862: SELECT
863: inventory_item_id
864: FROM
865: cst_pac_item_costs
866: WHERE pac_period_id = p_pac_period_id
867: AND cost_group_id = p_cost_group_id
868: AND inventory_item_id BETWEEN p_item_from AND p_item_to;
869:

Line 908: cst_pac_item_costs

904: market_value
905: INTO
906: l_market_value
907: FROM
908: cst_pac_item_costs
909: WHERE pac_period_id = p_pac_period_id
910: AND inventory_item_id = l_current_item
911: AND cost_group_id = p_cost_group_id;
912:

Line 948: , cst_pac_item_costs pic

944: FROM
945: cst_cost_groups cg
946: , cst_le_cost_types clt
947: , cst_pac_periods pp
948: , cst_pac_item_costs pic
949: , cst_pac_quantity_layers pql
950: , mtl_system_items msi
951: , mtl_system_items_kfv kfv
952: WHERE clt.legal_entity = p_legal_entity_id

Line 1007: , cst_pac_item_costs pic

1003: FROM
1004: cst_cost_groups cg
1005: , cst_le_cost_types clt
1006: , cst_pac_periods pp
1007: , cst_pac_item_costs pic
1008: , cst_pac_quantity_layers pql
1009: , mtl_system_items msi
1010: , mtl_system_items_kfv kfv
1011: WHERE clt.legal_entity = p_legal_entity_id

Line 1089: cst_pac_item_costs

1085: CURSOR item_cur IS
1086: SELECT
1087: inventory_item_id
1088: FROM
1089: cst_pac_item_costs
1090: WHERE pac_period_id = p_pac_period_id
1091: AND cost_group_id = p_cost_group_id
1092: AND inventory_item_id BETWEEN p_item_from AND p_item_to;
1093:

Line 1153: cst_pac_item_costs

1149: market_value
1150: INTO
1151: l_market_value
1152: FROM
1153: cst_pac_item_costs
1154: WHERE pac_period_id = g_period_tab(g_current_period_index)
1155: AND inventory_item_id = l_current_item
1156: AND cost_group_id = p_cost_group_id;
1157:

Line 1195: , cst_pac_item_costs pic

1191: FROM
1192: cst_cost_groups cg
1193: , cst_le_cost_types clt
1194: , cst_pac_periods pp
1195: , cst_pac_item_costs pic
1196: , cst_pac_quantity_layers pql
1197: , mtl_system_items msi
1198: , mtl_system_items_kfv kfv
1199: WHERE clt.legal_entity = p_legal_entity_id

Line 1251: , cst_pac_item_costs pic

1247: FROM
1248: cst_cost_groups cg
1249: , cst_le_cost_types clt
1250: , cst_pac_periods pp
1251: , cst_pac_item_costs pic
1252: , cst_pac_quantity_layers pql
1253: , mtl_system_items msi
1254: , mtl_system_items_kfv kfv
1255: WHERE clt.legal_entity = p_legal_entity_id

Line 1321: , cst_pac_item_costs pic

1317: FROM
1318: cst_cost_groups cg
1319: , cst_le_cost_types clt
1320: , cst_pac_periods pp
1321: , cst_pac_item_costs pic
1322: , cst_pac_quantity_layers pql
1323: , mtl_system_items msi
1324: , mtl_system_items_kfv kfv
1325: WHERE clt.legal_entity = p_legal_entity_id

Line 1382: , cst_pac_item_costs pic

1378: FROM
1379: cst_cost_groups cg
1380: , cst_le_cost_types clt
1381: , cst_pac_periods pp
1382: , cst_pac_item_costs pic
1383: , cst_pac_quantity_layers pql
1384: , mtl_system_items msi
1385: , mtl_system_items_kfv kfv
1386: WHERE clt.legal_entity = p_legal_entity_id

Line 1496: cst_pac_item_costs

1492: INTO
1493: l_item_from
1494: , l_item_to
1495: FROM
1496: cst_pac_item_costs
1497: WHERE cost_group_id = p_cost_group_id
1498: AND pac_period_id = p_pac_period_id;
1499:
1500: -- Find if the :from or :to range paramenters have values

Line 2063: FROM CST_PAC_ITEM_COSTS

2059: ,c_item_id NUMBER)
2060: IS
2061: SELECT
2062: market_value
2063: FROM CST_PAC_ITEM_COSTS
2064: WHERE pac_period_id = c_period_id
2065: AND cost_group_id = c_cost_group_id
2066: AND inventory_item_id = c_item_id;
2067:

Line 2108: FROM CST_PAC_ITEM_COSTS

2104: c_first_period_end_date DATE)
2105: IS
2106: SELECT
2107: COUNT(*)
2108: FROM CST_PAC_ITEM_COSTS
2109: WHERE cost_group_id = c_cost_group_id
2110: AND inventory_item_id = c_item_id
2111: AND pac_period_id IN (SELECT pac_period_id
2112: FROM CST_PAC_PERIODS

Line 2208: DELETE CST_PAC_ITEM_COSTS

2204:
2205: CLOSE get_purge_prior_cnt_cur;
2206:
2207: -- Delete all the prior item costs
2208: DELETE CST_PAC_ITEM_COSTS
2209: WHERE cost_group_id = p_cost_group_id
2210: AND inventory_item_id = p_item_id
2211: AND pac_period_id IN (SELECT pac_period_id
2212: FROM CST_PAC_PERIODS

Line 2302: DELETE CST_PAC_ITEM_COSTS

2298:
2299: -- delete the layer if the delta is negative or 0
2300: IF (l_layer_quantity <= 0) THEN
2301:
2302: DELETE CST_PAC_ITEM_COSTS
2303: WHERE pac_period_id = l_period_id
2304: AND inventory_item_id = p_item_id
2305: AND cost_group_id = p_cost_group_id;
2306:

Line 2321: UPDATE CST_PAC_ITEM_COSTS

2317: l_period_id :=
2318: CST_MGD_LIFO_COST_PROCESSOR.g_period_tab(l_period_index);
2319:
2320: -- add delta to the end quantity of the previous period item costs
2321: UPDATE CST_PAC_ITEM_COSTS
2322: SET total_layer_quantity = total_layer_quantity + l_layer_quantity
2323: WHERE pac_period_id = l_period_id
2324: AND inventory_item_id = p_item_id
2325: AND cost_group_id = p_cost_group_id;

Line 2365: DELETE CST_PAC_ITEM_COSTS

2361: CLOSE get_layer_quantity_cur;
2362:
2363: IF ((l_first_layer_quantity <= 0) AND ( l_market_value IS NULL)) THEN
2364: -- Delete the item cost and quantity layer
2365: DELETE CST_PAC_ITEM_COSTS
2366: WHERE pac_period_id = p_first_period_id
2367: AND inventory_item_id = p_item_id
2368: AND cost_group_id = p_cost_group_id;
2369:

Line 2384: FROM CST_PAC_ITEM_COSTS

2380: -- Update delta to the end quantity
2381: UPDATE CST_PAC_QUANTITY_LAYERS
2382: SET begin_layer_quantity = 0,
2383: layer_quantity = (SELECT total_layer_quantity
2384: FROM CST_PAC_ITEM_COSTS
2385: WHERE pac_period_id = p_first_period_id
2386: AND inventory_item_id = p_item_id
2387: AND cost_group_id = p_cost_group_id)
2388: WHERE pac_period_id = p_first_period_id

Line 2507: ,CST_PAC_ITEM_COSTS pic

2503: msi.concatenated_segments item_number,
2504: msi.inventory_item_id
2505: FROM
2506: CST_PAC_PERIODS pp
2507: ,CST_PAC_ITEM_COSTS pic
2508: ,MTL_SYSTEM_ITEMS_KFV msi
2509: ,MTL_ITEM_CATEGORIES mic
2510: ,MTL_CATEGORIES_KFV mc
2511: WHERE pp.legal_entity = c_legal_entity_id

Line 2682: cst_pac_item_costs

2678: total_layer_quantity
2679: INTO
2680: l_total_quantity
2681: FROM
2682: cst_pac_item_costs
2683: WHERE pac_period_id = l_first_period_id
2684: AND inventory_item_id = l_inventory_item_id
2685: AND cost_group_id = p_cost_group_id;
2686: