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.

[Home] [Help]

APPS.CSTPFCHK dependencies on CST_PAC_ITEM_COSTS

Line 48: --| CST_PAC_ITEM_COSTS_V with base table |

44: --| 01/07/2005 vjavli FP:11i8-12.0:Bug 4028737 fix:begin layer quantity |
45: --| initialized to total layer quantity of previous |
46: --| period. Base bug 3775498 fix. |
47: --| 05/24/2006 vmutyala Bug 5239716 : Replaced Non Mergeable View |
48: --| CST_PAC_ITEM_COSTS_V with base table |
49: --| CST_PAC_ITEM_COST_DETAILS |
50: --| 02/07/2008 vjavli Bug 6751847 performance fix: i_txn_category |
51: --| parameter added to procedures compute_pac_cost_ |
52: --| hook, calc_pac_cost_hook and periodic_cost_update_|

Line 570: FROM cst_pac_item_costs

566: make_quantity
567: INTO l_cur_onhand,
568: l_cur_buy_qty,
569: l_cur_make_qty
570: FROM cst_pac_item_costs
571: WHERE cost_layer_id = i_cost_layer_id;
572:
573:
574: /********************************************************************

Line 704: UPDATE cst_pac_item_costs cpic

700: ** Update layer quantity and layer costs information **
701: ********************************************************************/
702: l_stmt_num := 80;
703:
704: UPDATE cst_pac_item_costs cpic
705: SET (last_updated_by,
706: last_update_date,
707: last_update_login,
708: request_id,

Line 769: -- CST_PAC_ITEM_COSTS.item_cost.

765: SUM(DECODE(LEVEL_TYPE,2,ITEM_COST,0)),
766: SUM(DECODE(LEVEL_TYPE,1,ITEM_COST,0)),
767: -- The following value is a change from the
768: -- code for PAC. 0 is inserted into
769: -- CST_PAC_ITEM_COSTS.item_cost.
770: 0,
771: SUM(ITEM_BUY_COST),
772: SUM(ITEM_MAKE_COST),
773: SUM(DECODE(COST_ELEMENT_ID,2,DECODE(LEVEL_TYPE,2,ITEM_COST,0),ITEM_COST)),

Line 875: UPDATE cst_pac_item_costs cpic

871: else
872:
873: l_stmt_num := 10;
874:
875: UPDATE cst_pac_item_costs cpic
876: SET last_update_date = sysdate,
877: last_updated_by = i_user_id,
878: last_update_login = i_login_id,
879: request_id = i_req_id,

Line 1019: FROM cst_pac_item_costs cpic

1015: PROCESS_ERROR EXCEPTION;
1016:
1017: CURSOR prior_period_cost_cursor IS
1018: SELECT cost_layer_id
1019: FROM cst_pac_item_costs cpic
1020: WHERE cpic.pac_period_id = i_prior_pac_period_id
1021: AND cpic.cost_group_id = i_cost_group_id;
1022:
1023: CURSOR prior_period_quantity_cursor (P_cost_layer_id number) IS

Line 1064: FROM cst_pac_item_costs

1060: l_stmt_num := 10;
1061: l_count := 0;
1062: SELECT count(*)
1063: INTO l_count
1064: FROM cst_pac_item_costs
1065: WHERE pac_period_id = i_pac_period_id
1066: AND cost_group_id = i_cost_group_id;
1067:
1068: IF (l_count <> 0) THEN

Line 1087: -- 1. cst_pac_item_costs --

1083:
1084:
1085: --------------------------------------------------------------------------------
1086: -- Copy data from previous period to current period of the following tables : --
1087: -- 1. cst_pac_item_costs --
1088: -- 2. cst_pac_item_cost_details --
1089: -- 3. cst_pac_quantity_layers --
1090: -- New cost_layer_id and quantity_layer_id are generated for every rows --
1091: -- inserted. --

Line 1095: SELECT cst_pac_item_costs_s.nextval

1091: -- inserted. --
1092: --------------------------------------------------------------------------------
1093: FOR l_prior_period_cost IN prior_period_cost_cursor LOOP
1094:
1095: SELECT cst_pac_item_costs_s.nextval
1096: INTO l_cost_layer_id
1097: FROM dual;
1098:
1099: -------------------------------------------

Line 1100: -- Copy prior info of CST_PAC_ITEM_COSTS --

1096: INTO l_cost_layer_id
1097: FROM dual;
1098:
1099: -------------------------------------------
1100: -- Copy prior info of CST_PAC_ITEM_COSTS --
1101: -------------------------------------------
1102: l_stmt_num := 30;
1103: INSERT INTO cst_pac_item_costs (
1104: cost_layer_id,

Line 1103: INSERT INTO cst_pac_item_costs (

1099: -------------------------------------------
1100: -- Copy prior info of CST_PAC_ITEM_COSTS --
1101: -------------------------------------------
1102: l_stmt_num := 30;
1103: INSERT INTO cst_pac_item_costs (
1104: cost_layer_id,
1105: pac_period_id,
1106: cost_group_id,
1107: inventory_item_id,

Line 1185: FROM cst_pac_item_costs cpic

1181: i_prog_app_id,
1182: i_prog_id,
1183: SYSDATE,
1184: i_login_id
1185: FROM cst_pac_item_costs cpic
1186: WHERE cpic.cost_layer_id = l_prior_period_cost.cost_layer_id;
1187:
1188: --------------------------------------------------
1189: -- Copy prior info of CST_PAC_ITEM_COST_DETAILS --

Line 1280: FROM cst_pac_item_costs

1276: -- =============================================================================
1277: l_stmt_num := 55;
1278: UPDATE cst_pac_quantity_layers
1279: SET begin_layer_quantity = (SELECT total_layer_quantity
1280: FROM cst_pac_item_costs
1281: WHERE cost_layer_id = l_prior_period_cost.cost_layer_id)
1282: WHERE quantity_layer_id = l_quantity_layer_id;
1283:
1284:

Line 1843: UPDATE cst_pac_item_costs cpic

1839: AND mptcd.pac_period_id = i_pac_period_id
1840: AND mptcd.cost_group_id = i_cost_group_id;
1841:
1842: l_stmt_num := 50;
1843: UPDATE cst_pac_item_costs cpic
1844: SET (last_updated_by,
1845: last_update_date,
1846: last_update_login,
1847: request_id,