APPS.CST_EAMCOST_PUB dependencies on CST_EAM_HIERARCHY_SNAPSHOT

Line 5397: -- and put it into CST_EAM_HIERARCHY_SNAPSHOT

5393:
5394: ------------------------------------------------
5395: -- Take a snapshot of hierarchy structure from
5396: -- MTL_OBJECT_GENEALOGY
5397: -- and put it into CST_EAM_HIERARCHY_SNAPSHOT
5398: -- using l_gen_object_id and all it's child
5399: ------------------------------------------------
5400:
5401: -----------------------------------------------

Line 5407: /*INSERT INTO cst_eam_hierarchy_snapshot

5403: -- for bug#15907393 as l_statement := 60 insert statement
5404: -- may include multiple parent record if multiple parent_object_id
5405: -- exist.
5406: --l_statement := 60;
5407: /*INSERT INTO cst_eam_hierarchy_snapshot
5408: (group_id,
5409: object_type,
5410: object_id,
5411: parent_object_type,

Line 5452: -- insert one row into CST_EAM_HIERARCHY_SNAPSHOT

5448: NVL(l_period_end_date,START_DATE_ACTIVE)); */
5449:
5450: ------------------------------------------------
5451: -- check for single asset. If it's the case
5452: -- insert one row into CST_EAM_HIERARCHY_SNAPSHOT
5453: ------------------------------------------------
5454: /*l_statement := 65;
5455: SELECT count(*)
5456: INTO l_count

Line 5457: FROM cst_eam_hierarchy_snapshot

5453: ------------------------------------------------
5454: /*l_statement := 65;
5455: SELECT count(*)
5456: INTO l_count
5457: FROM cst_eam_hierarchy_snapshot
5458: WHERE group_id = x_group_id; */
5459:
5460: --IF (l_count = 0) THEN
5461:

Line 5465: INSERT INTO cst_eam_hierarchy_snapshot

5461:
5462: l_statement := 70;
5463:
5464: /* AMONDAL's fix, updated by DLE */
5465: INSERT INTO cst_eam_hierarchy_snapshot
5466: (group_id,
5467: object_type,
5468: object_id,
5469: parent_object_type,

Line 5515: INSERT INTO cst_eam_hierarchy_snapshot

5511:
5512: /* end of AMONDAL's fix */
5513: l_statement := 75;
5514:
5515: INSERT INTO cst_eam_hierarchy_snapshot
5516: (group_id,
5517: object_type,
5518: object_id,
5519: parent_object_type,

Line 5671: from cst_eam_hierarchy_snapshot

5667: FROM cst_eam_asset_per_balances ceapb,
5668: mtl_serial_numbers msn,
5669: --Bug#16095661: Distinct group_id, object
5670: (select DISTINCT group_id, object_id
5671: from cst_eam_hierarchy_snapshot
5672: where group_id = x_group_id ) cehs
5673: WHERE ceapb.organization_id = l_org_id
5674: AND ceapb.inventory_item_id = msn.inventory_item_id
5675: AND ceapb.serial_number = msn.serial_number

Line 5762: -- group_id in cst_eam_hierarchy_snapshot

5758: -- Function : Rollup total cost for Asset Item
5759: -- Parameters
5760: -- IN :
5761: -- p_group_id IN VARCHAR2 Required
5762: -- group_id in cst_eam_hierarchy_snapshot
5763: -- cst_eam_rollup_temp
5764: --
5765: -- Version :
5766: --

Line 5826: DELETE cst_eam_hierarchy_snapshot

5822: -------------------------------------------------------------
5823: -- Purge cst_am_hierarchy_snapshot
5824: -------------------------------------------------------------
5825: l_statement := 40;
5826: DELETE cst_eam_hierarchy_snapshot
5827: WHERE group_id= p_group_id;
5828:
5829: -------------------------------------------------------------
5830: -- Pruge cst_eam_rollup_temp

Line 9805: FROM cst_eam_hierarchy_snapshot

9801:
9802: l_stmt_num := 5;
9803: SELECT count(*)
9804: INTO l_object_type_count
9805: FROM cst_eam_hierarchy_snapshot
9806: WHERE group_id = p_group_id
9807: AND (object_type IS NULL OR parent_object_type IS NULL);
9808:
9809: IF l_object_type_count <> 0 THEN

Line 9817: FROM cst_eam_hierarchy_snapshot

9813: -- Calculate the depth of the hierarchy
9814: l_stmt_num := 10;
9815: SELECT MAX(level_num)
9816: INTO l_max_level
9817: FROM cst_eam_hierarchy_snapshot
9818: WHERE group_id = p_group_id;
9819:
9820: -- Generate a warning if there is no matching record in the supplied group id
9821: l_stmt_num := 15;

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

9823: THEN
9824: FND_MSG_PUB.Add_Exc_Msg(
9825: p_pkg_name => G_PKG_NAME,
9826: p_procedure_name => l_api_name,
9827: p_error_text => 'There is no matching record in CST_EAM_HIERARCHY_SNAPSHOT ' ||
9828: 'for group id ' || p_group_id
9829: );
9830: x_return_status := FND_API.G_RET_STS_SUCCESS;
9831: RETURN;

Line 9904: FROM cst_eam_hierarchy_snapshot CURR,

9900: SUM(NVL(WEPB.actual_eqp_cost,0)) actual_eqp_cost,
9901: SUM(NVL(WEPB.system_estimated_mat_cost,0)) estimated_mat_cost,
9902: SUM(NVL(WEPB.system_estimated_lab_cost,0)) estimated_lab_cost,
9903: SUM(NVL(WEPB.system_estimated_eqp_cost,0)) estimated_eqp_cost
9904: FROM cst_eam_hierarchy_snapshot CURR,
9905: wip_eam_period_balances WEPB
9906: WHERE CURR.group_id = p_group_id
9907: AND CURR.level_num = l_level
9908: AND CURR.object_type = 2 -- WIP job

Line 9931: FROM cst_eam_hierarchy_snapshot CURR,

9927: SUM(NVL(CERC.actual_eqp_cost,0)),
9928: SUM(NVL(CERC.estimated_mat_cost,0)),
9929: SUM(NVL(CERC.estimated_lab_cost,0)),
9930: SUM(NVL(CERC.estimated_eqp_cost,0))
9931: FROM cst_eam_hierarchy_snapshot CURR,
9932: cst_eam_hierarchy_snapshot CHILDREN,
9933: cst_eam_rollup_costs CERC
9934: WHERE CURR.group_id = p_group_id
9935: AND CURR.level_num = l_level

Line 9932: cst_eam_hierarchy_snapshot CHILDREN,

9928: SUM(NVL(CERC.estimated_mat_cost,0)),
9929: SUM(NVL(CERC.estimated_lab_cost,0)),
9930: SUM(NVL(CERC.estimated_eqp_cost,0))
9931: FROM cst_eam_hierarchy_snapshot CURR,
9932: cst_eam_hierarchy_snapshot CHILDREN,
9933: cst_eam_rollup_costs CERC
9934: WHERE CURR.group_id = p_group_id
9935: AND CURR.level_num = l_level
9936: AND CHILDREN.group_id = p_group_id

Line 10053: DELETE cst_eam_hierarchy_snapshot

10049: );
10050: END IF;
10051:
10052: l_stmt_num := 10;
10053: DELETE cst_eam_hierarchy_snapshot
10054: WHERE group_id = NVL(p_group_id,group_id)
10055: AND program_application_id =
10056: NVL(p_prog_appl_id,program_application_id)
10057: AND last_update_date < NVL(p_last_update_date,last_update_date+1);