APPS.CST_MGD_LIFO_COST_PROCESSOR dependencies on CST_PAC_PERIODS

Line 115: cst_pac_periods.pac_period_id

111: --================
112:
113: CURSOR period_cur IS
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

Line 117: cst_pac_periods,

113: CURSOR period_cur IS
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

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 122: AND cst_pac_periods.cost_type_id = p_cost_type_id

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:
126:

Line 123: ORDER BY cst_pac_periods.period_year, cst_pac_periods.period_num;

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:
126:
127: --=================

Line 286: FROM CST_PAC_PERIODS

282: AND inventory_item_id = c_inventory_item_id;
283:
284: CURSOR get_period_status_cur(c_period_id NUMBER) IS
285: SELECT open_flag
286: FROM CST_PAC_PERIODS
287: WHERE pac_period_id = c_period_id;
288:
289:
290: --=================

Line 947: , cst_pac_periods pp

943: , (pic.item_cost * pic.total_layer_quantity)
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

Line 1006: , cst_pac_periods pp

1002: , (pic.market_value * pic.total_layer_quantity)
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

Line 1194: , cst_pac_periods pp

1190: , (pic.item_cost * pic.total_layer_quantity)
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

Line 1250: , cst_pac_periods pp

1246: , (pic.market_value * pic.total_layer_quantity)
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

Line 1320: , cst_pac_periods pp

1316: , (pic.item_cost * pic.total_layer_quantity)
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

Line 1381: , cst_pac_periods pp

1377: , (pic.market_value * pic.total_layer_quantity)
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

Line 1614: FROM cst_pac_periods cpp

1610: l_stmt_num := 1;
1611:
1612: SELECT cpp.pac_period_id
1613: INTO p_pac_period_id
1614: FROM cst_pac_periods cpp
1615: WHERE (cpp.period_name, cpp.cost_type_id) =
1616: ( SELECT cpici.period_name,
1617: cct.cost_type_id
1618: FROM cst_pc_item_cost_interface cpici,

Line 2098: FROM CST_PAC_PERIODS

2094: CURSOR get_period_end_date_cur(c_period_id NUMBER)
2095: IS
2096: SELECT
2097: period_end_date
2098: FROM CST_PAC_PERIODS
2099: WHERE pac_period_id = c_period_id;
2100:
2101: -- cursor to obtain the prior purge count
2102: CURSOR get_purge_prior_cnt_cur(c_cost_group_id NUMBER,

Line 2112: FROM CST_PAC_PERIODS

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
2113: WHERE period_end_date
2114: < c_first_period_end_date);
2115:
2116:

Line 2212: FROM CST_PAC_PERIODS

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
2213: WHERE period_end_date
2214: < l_first_period_end_date);
2215:
2216:

Line 2222: FROM CST_PAC_PERIODS

2218: DELETE CST_PAC_QUANTITY_LAYERS
2219: WHERE cost_group_id = p_cost_group_id
2220: AND inventory_item_id = p_item_id
2221: AND pac_period_id IN (SELECT pac_period_id
2222: FROM CST_PAC_PERIODS
2223: WHERE period_end_date
2224: < l_first_period_end_date);
2225:
2226:

Line 2506: CST_PAC_PERIODS pp

2502: SELECT
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