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 1059: FROM cst_pac_item_costs

1055: l_stmt_num := 10;
1056: l_count := 0;
1057: SELECT count(*)
1058: INTO l_count
1059: FROM cst_pac_item_costs
1060: WHERE pac_period_id = i_pac_period_id
1061: AND cost_group_id = i_cost_group_id;
1062:
1063: IF (l_count <> 0) THEN

Line 1082: -- 1. cst_pac_item_costs --

1078:
1079:
1080: --------------------------------------------------------------------------------
1081: -- Copy data from previous period to current period of the following tables : --
1082: -- 1. cst_pac_item_costs --
1083: -- 2. cst_pac_item_cost_details --
1084: -- 3. cst_pac_quantity_layers --
1085: -- New cost_layer_id and quantity_layer_id are generated for every rows --
1086: -- inserted. --

Line 1090: SELECT cst_pac_item_costs_s.nextval

1086: -- inserted. --
1087: --------------------------------------------------------------------------------
1088: FOR l_prior_period_cost IN prior_period_cost_cursor LOOP
1089:
1090: SELECT cst_pac_item_costs_s.nextval
1091: INTO l_cost_layer_id
1092: FROM dual;
1093:
1094: -------------------------------------------

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

1091: INTO l_cost_layer_id
1092: FROM dual;
1093:
1094: -------------------------------------------
1095: -- Copy prior info of CST_PAC_ITEM_COSTS --
1096: -------------------------------------------
1097: l_stmt_num := 30;
1098: INSERT INTO cst_pac_item_costs (
1099: cost_layer_id,

Line 1098: INSERT INTO cst_pac_item_costs (

1094: -------------------------------------------
1095: -- Copy prior info of CST_PAC_ITEM_COSTS --
1096: -------------------------------------------
1097: l_stmt_num := 30;
1098: INSERT INTO cst_pac_item_costs (
1099: cost_layer_id,
1100: pac_period_id,
1101: cost_group_id,
1102: inventory_item_id,

Line 1180: FROM cst_pac_item_costs cpic

1176: i_prog_app_id,
1177: i_prog_id,
1178: SYSDATE,
1179: i_login_id
1180: FROM cst_pac_item_costs cpic
1181: WHERE cpic.cost_layer_id = l_prior_period_cost.cost_layer_id;
1182:
1183: --------------------------------------------------
1184: -- Copy prior info of CST_PAC_ITEM_COST_DETAILS --

Line 1275: FROM cst_pac_item_costs

1271: -- =============================================================================
1272: l_stmt_num := 55;
1273: UPDATE cst_pac_quantity_layers
1274: SET begin_layer_quantity = (SELECT total_layer_quantity
1275: FROM cst_pac_item_costs
1276: WHERE cost_layer_id = l_prior_period_cost.cost_layer_id)
1277: WHERE quantity_layer_id = l_quantity_layer_id;
1278:
1279:

Line 1838: UPDATE cst_pac_item_costs cpic

1834: AND mptcd.pac_period_id = i_pac_period_id
1835: AND mptcd.cost_group_id = i_cost_group_id;
1836:
1837: l_stmt_num := 50;
1838: UPDATE cst_pac_item_costs cpic
1839: SET (last_updated_by,
1840: last_update_date,
1841: last_update_login,
1842: request_id,