APPS.CSTPPCIC dependencies on CST_ITEM_COST_DETAILS

Line 58: | CST_ITEM_COST_DETAILS.basis_factor = 1 |

54: | |
55: | CST_ITEM_COSTS.defaulted_flag = 2 (Do not use default cost controls) |
56: | CST_ITEM_COSTS.cost_update_id = NULL |
57: | CST_ITEM_COSTS.based_on_rollup_flag = 1 |
58: | CST_ITEM_COST_DETAILS.basis_factor = 1 |
59: | CST_ITEM_COST_DETAILS.rollup_source_type = 1(User defined) |
60: | |
61: *----------------------------------------------------------------------------*/
62: PROCEDURE copy_item_period_cost(

Line 59: | CST_ITEM_COST_DETAILS.rollup_source_type = 1(User defined) |

55: | CST_ITEM_COSTS.defaulted_flag = 2 (Do not use default cost controls) |
56: | CST_ITEM_COSTS.cost_update_id = NULL |
57: | CST_ITEM_COSTS.based_on_rollup_flag = 1 |
58: | CST_ITEM_COST_DETAILS.basis_factor = 1 |
59: | CST_ITEM_COST_DETAILS.rollup_source_type = 1(User defined) |
60: | |
61: *----------------------------------------------------------------------------*/
62: PROCEDURE copy_item_period_cost(
63: errbuf OUT NOCOPY VARCHAR2,

Line 548: DELETE cst_item_cost_details CICD

544:
545: l_stmt_num := 35;
546:
547:
548: DELETE cst_item_cost_details CICD
549: WHERE CICD.cost_type_id = p_to_cost_type_id
550: AND CICD.organization_id = p_to_org_id
551: AND (p_range = 1
552: OR

Line 840: INSERT INTO cst_item_cost_details

836:
837: l_stmt_num := 60;
838:
839:
840: INSERT INTO cst_item_cost_details
841: ( inventory_item_id
842: , organization_id
843: , cost_type_id
844: , last_update_date

Line 1113: INSERT INTO cst_item_cost_details

1109:
1110: l_stmt_num := 80;
1111:
1112:
1113: INSERT INTO cst_item_cost_details
1114: ( inventory_item_id
1115: , organization_id
1116: , cost_type_id
1117: , last_update_date

Line 1204: FROM cst_item_cost_details CICD

1200: AND CIC.inventory_item_id = CPIC.inventory_item_id)
1201: */
1202: AND NOT EXISTS
1203: (SELECT 'x'
1204: FROM cst_item_cost_details CICD
1205: WHERE CICD.cost_type_id = p_to_cost_type_id
1206: AND CICD.organization_id = p_to_org_id
1207: AND CICD.inventory_item_id = CPIC.inventory_item_id);
1208:

Line 1242: DELETE cst_item_cost_details CICD

1238:
1239: l_stmt_num := 90;
1240:
1241:
1242: DELETE cst_item_cost_details CICD
1243: WHERE CICD.cost_type_id = p_to_cost_type_id
1244: AND CICD.organization_id = p_to_org_id
1245: AND (p_range = 1
1246: OR

Line 1522: INSERT INTO cst_item_cost_details

1518:
1519: l_stmt_num := 120;
1520:
1521:
1522: INSERT INTO cst_item_cost_details
1523: ( inventory_item_id
1524: , organization_id
1525: , cost_type_id
1526: , last_update_date