APPS.CST_EAMCOST_PUB dependencies on CST_EAM_HIERARCHY_SNAPSHOT

Line 5133: -- and put it into CST_EAM_HIERARCHY_SNAPSHOT

5129:
5130: ------------------------------------------------
5131: -- Take a snapshot of hierarchy structure from
5132: -- MTL_OBJECT_GENEALOGY
5133: -- and put it into CST_EAM_HIERARCHY_SNAPSHOT
5134: -- using l_gen_object_id and all it's child
5135: ------------------------------------------------
5136: l_statement := 50;
5137: INSERT INTO cst_eam_hierarchy_snapshot

Line 5137: INSERT INTO cst_eam_hierarchy_snapshot

5133: -- and put it into CST_EAM_HIERARCHY_SNAPSHOT
5134: -- using l_gen_object_id and all it's child
5135: ------------------------------------------------
5136: l_statement := 50;
5137: INSERT INTO cst_eam_hierarchy_snapshot
5138: (group_id,
5139: object_type,
5140: object_id,
5141: parent_object_type,

Line 5174: -- insert one row into CST_EAM_HIERARCHY_SNAPSHOT

5170: AND sysdate between start_date_active and nvl(end_date_active, sysdate);
5171:
5172: ------------------------------------------------
5173: -- check for single asset. If it's the case
5174: -- insert one row into CST_EAM_HIERARCHY_SNAPSHOT
5175: ------------------------------------------------
5176: l_statement := 51;
5177: SELECT count(*)
5178: INTO l_count

Line 5179: FROM cst_eam_hierarchy_snapshot

5175: ------------------------------------------------
5176: l_statement := 51;
5177: SELECT count(*)
5178: INTO l_count
5179: FROM cst_eam_hierarchy_snapshot
5180: WHERE group_id = x_group_id;
5181:
5182: l_statement := 52;
5183: IF (l_count = 0) THEN

Line 5186: INSERT INTO cst_eam_hierarchy_snapshot

5182: l_statement := 52;
5183: IF (l_count = 0) THEN
5184:
5185: /* AMONDAL's fix, updated by DLE */
5186: INSERT INTO cst_eam_hierarchy_snapshot
5187: (group_id,
5188: object_type,
5189: object_id,
5190: parent_object_type,

Line 5223: INSERT INTO cst_eam_hierarchy_snapshot

5219: AND sysdate between start_date_active and nvl(end_date_active, sysdate);
5220:
5221: /* end of AMONDAL's fix */
5222:
5223: INSERT INTO cst_eam_hierarchy_snapshot
5224: (group_id,
5225: object_type,
5226: object_id,
5227: parent_object_type,

Line 5376: cst_eam_hierarchy_snapshot cehs

5372: NULL,
5373: NULL
5374: FROM cst_eam_asset_per_balances ceapb,
5375: mtl_serial_numbers msn,
5376: cst_eam_hierarchy_snapshot cehs
5377: WHERE
5378: ceapb.inventory_item_id = msn.inventory_item_id
5379: AND ceapb.serial_number = msn.serial_number
5380: AND msn.gen_object_id = cehs.object_id

Line 5466: -- group_id in cst_eam_hierarchy_snapshot

5462: -- Function : Rollup total cost for Asset Item
5463: -- Parameters
5464: -- IN :
5465: -- p_group_id IN VARCHAR2 Required
5466: -- group_id in cst_eam_hierarchy_snapshot
5467: -- cst_eam_rollup_temp
5468: --
5469: -- Version :
5470: --

Line 5530: DELETE cst_eam_hierarchy_snapshot

5526: -------------------------------------------------------------
5527: -- Purge cst_am_hierarchy_snapshot
5528: -------------------------------------------------------------
5529: l_statement := 40;
5530: DELETE cst_eam_hierarchy_snapshot
5531: WHERE group_id= p_group_id;
5532:
5533: -------------------------------------------------------------
5534: -- Pruge cst_eam_rollup_temp

Line 9092: FROM cst_eam_hierarchy_snapshot

9088:
9089: l_stmt_num := 5;
9090: SELECT count(*)
9091: INTO l_object_type_count
9092: FROM cst_eam_hierarchy_snapshot
9093: WHERE group_id = p_group_id
9094: AND (object_type IS NULL OR parent_object_type IS NULL);
9095:
9096: IF l_object_type_count <> 0 THEN

Line 9104: FROM cst_eam_hierarchy_snapshot

9100: -- Calculate the depth of the hierarchy
9101: l_stmt_num := 10;
9102: SELECT MAX(level_num)
9103: INTO l_max_level
9104: FROM cst_eam_hierarchy_snapshot
9105: WHERE group_id = p_group_id;
9106:
9107: -- Generate a warning if there is no matching record in the supplied group id
9108: l_stmt_num := 15;

Line 9114: p_error_text => 'There is no matching record in CST_EAM_HIERARCHY_SNAPSHOT ' ||

9110: THEN
9111: FND_MSG_PUB.Add_Exc_Msg(
9112: p_pkg_name => G_PKG_NAME,
9113: p_procedure_name => l_api_name,
9114: p_error_text => 'There is no matching record in CST_EAM_HIERARCHY_SNAPSHOT ' ||
9115: 'for group id ' || p_group_id
9116: );
9117: x_return_status := FND_API.G_RET_STS_SUCCESS;
9118: RETURN;

Line 9191: FROM cst_eam_hierarchy_snapshot CURR,

9187: SUM(NVL(WEPB.actual_eqp_cost,0)) actual_eqp_cost,
9188: SUM(NVL(WEPB.system_estimated_mat_cost,0)) estimated_mat_cost,
9189: SUM(NVL(WEPB.system_estimated_lab_cost,0)) estimated_lab_cost,
9190: SUM(NVL(WEPB.system_estimated_eqp_cost,0)) estimated_eqp_cost
9191: FROM cst_eam_hierarchy_snapshot CURR,
9192: wip_eam_period_balances WEPB
9193: WHERE CURR.group_id = p_group_id
9194: AND CURR.level_num = l_level
9195: AND CURR.object_type = 2 -- WIP job

Line 9218: FROM cst_eam_hierarchy_snapshot CURR,

9214: SUM(NVL(CERC.actual_eqp_cost,0)),
9215: SUM(NVL(CERC.estimated_mat_cost,0)),
9216: SUM(NVL(CERC.estimated_lab_cost,0)),
9217: SUM(NVL(CERC.estimated_eqp_cost,0))
9218: FROM cst_eam_hierarchy_snapshot CURR,
9219: cst_eam_hierarchy_snapshot CHILDREN,
9220: cst_eam_rollup_costs CERC
9221: WHERE CURR.group_id = p_group_id
9222: AND CURR.level_num = l_level

Line 9219: cst_eam_hierarchy_snapshot CHILDREN,

9215: SUM(NVL(CERC.estimated_mat_cost,0)),
9216: SUM(NVL(CERC.estimated_lab_cost,0)),
9217: SUM(NVL(CERC.estimated_eqp_cost,0))
9218: FROM cst_eam_hierarchy_snapshot CURR,
9219: cst_eam_hierarchy_snapshot CHILDREN,
9220: cst_eam_rollup_costs CERC
9221: WHERE CURR.group_id = p_group_id
9222: AND CURR.level_num = l_level
9223: AND CHILDREN.group_id = p_group_id

Line 9340: DELETE cst_eam_hierarchy_snapshot

9336: );
9337: END IF;
9338:
9339: l_stmt_num := 10;
9340: DELETE cst_eam_hierarchy_snapshot
9341: WHERE group_id = NVL(p_group_id,group_id)
9342: AND program_application_id =
9343: NVL(p_prog_appl_id,program_application_id)
9344: AND last_update_date < NVL(p_last_update_date,last_update_date+1);