eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_EAMCOST_PUB dependencies on CST_EAM_ASSET_PER_BALANCES

Line 417: -- This API insert or updates WIP_EAM_PERIOD_BALANCES and CST_EAM_ASSET_PER_BALANCES

413: -- PROCEDURE
414: -- Update_eamCost
415: --
416: -- DESCRIPTION
417: -- This API insert or updates WIP_EAM_PERIOD_BALANCES and CST_EAM_ASSET_PER_BALANCES
418: -- with the amount passed by the calling program.
419: --
420: -- PURPOSE:
421: -- Support eAM job costing in Oracle Applications Rel 11i

Line 453: -- WIP_EAM_PERIOD_BALANCES and CST_EAM_ASSET_PER_BALANCES with the estimated

449: -- on the resource type, and the dept type of the owning department.
450: --
451: -- ESTIMATED COSTS:
452: -- The eAM cost estimating process will call this API to populate
453: -- WIP_EAM_PERIOD_BALANCES and CST_EAM_ASSET_PER_BALANCES with the estimated
454: -- cost values. If it is a re-estimate, the calling program should back out the
455: -- old estimates from both WIP_EAM_PERIOD_BALANCES and CST_EAM_ASSET_PER_BALANCES
456: -- before calling this API and passing the new estimates to avoid duplication.
457: /* =============================================================================== */

Line 455: -- old estimates from both WIP_EAM_PERIOD_BALANCES and CST_EAM_ASSET_PER_BALANCES

451: -- ESTIMATED COSTS:
452: -- The eAM cost estimating process will call this API to populate
453: -- WIP_EAM_PERIOD_BALANCES and CST_EAM_ASSET_PER_BALANCES with the estimated
454: -- cost values. If it is a re-estimate, the calling program should back out the
455: -- old estimates from both WIP_EAM_PERIOD_BALANCES and CST_EAM_ASSET_PER_BALANCES
456: -- before calling this API and passing the new estimates to avoid duplication.
457: /* =============================================================================== */
458:
459: PROCEDURE Update_eamCost (

Line 788: -- cst_eam_asset_per_balances.

784: -- DESCRIPTION
785: -- This procedure inserts or updates a row in wip_eam_period_balances table,
786: -- according to the parameters passed by the calling program.
787: -- Subsequently, it also inserts or update the related row in
788: -- cst_eam_asset_per_balances.
789: --
790: -- PURPOSE
791: -- Oracle Application Rel 11i.5
792: -- eAM Job Costing support

Line 1330: FND_FILE.PUT_LINE(fnd_file.log,'inserted into cst_eam_asset_per_balances' );

1326:
1327: end if;
1328:
1329: if (l_debug = 'Y') then
1330: FND_FILE.PUT_LINE(fnd_file.log,'inserted into cst_eam_asset_per_balances' );
1331: end if;
1332:
1333: -- Standard check of p_commit
1334: IF FND_API.to_Boolean(p_commit) THEN

Line 1419: -- CST_EAM_ASSET_PER_BALANCES table will now

1415: --
1416: -- HISTORY
1417: -- 03/27/05 Anjali R Added p_maint_obj_id and p_maint_obj_type parameters
1418: -- for eAM Requirements Project - R12.
1419: -- CST_EAM_ASSET_PER_BALANCES table will now
1420: -- store corresponding IB Instance_id for each
1421: -- serialized asset or serialized rebuildable.
1422: -- For non-serialized rebuildable item, it will
1423: -- store MSI.inventory_item_id.

Line 1506: FROM cst_eam_asset_per_balances

1502: l_count := 0;
1503:
1504: SELECT count(*)
1505: INTO l_count
1506: FROM cst_eam_asset_per_balances
1507: WHERE period_set_name = p_period_set_name AND
1508: period_name = p_period_name AND
1509: organization_id = p_org_id AND
1510: inventory_item_id = p_asset_group_id AND

Line 1519: l_statement := 'UPDATE cst_eam_asset_per_balances SET '

1515: l_stmt_num := 180;
1516: /* Bug 2545791: Using bind variables to construct statement */
1517: /* Bug 2935692: Change statement to use bind variables even in SET clause. */
1518:
1519: l_statement := 'UPDATE cst_eam_asset_per_balances SET '
1520: || p_column || '='
1521: || 'nvl('|| p_column || ',0) + nvl(:p_value,0)'
1522: || ', last_update_date = sysdate'
1523: || ', last_updated_by = :p_user_id'

Line 1537: INSERT INTO cst_eam_asset_per_balances (

1533: p_maint_cost_cat ;
1534:
1535: ELSE
1536: l_stmt_num := 190;
1537: INSERT INTO cst_eam_asset_per_balances (
1538: period_set_name,
1539: period_name,
1540: acct_period_id,
1541: organization_id,

Line 1950: -- cst_eam_asset_per_balances. --

1946: -- This API removes the cost of a specific type, such as system --
1947: -- or manual estimates from wip_eam_per_balances and delete the rows --
1948: -- if all the costs are zeros. It also update the corresponding amount --
1949: -- It also update the corresponding amount in --
1950: -- cst_eam_asset_per_balances. --
1951: -- NOTE: This process is at the wip entity level. --
1952: -- --
1953: -- p_type = 1 (system estimates) --
1954: -- 2 (manual estimates) --

Line 2114: -- Update cst_eam_asset_per_balances first before

2110: and maintenance_object_type =3;
2111: end if;
2112: End if;
2113: -----------------------------------------------------
2114: -- Update cst_eam_asset_per_balances first before
2115: -- deleting wip_eam_period_balances
2116: -- If the asset on the work order is a route asset,
2117: -- then adjust asset value for the members
2118: ------------------------------------------------------

Line 2129: UPDATE cst_eam_asset_per_balances

2125: ( v_est_rec.sys_mat <> 0 OR
2126: v_est_rec.sys_lab <> 0 OR
2127: v_est_rec.sys_eqp <> 0) THEN
2128: l_stmt_num := 312;
2129: UPDATE cst_eam_asset_per_balances
2130: SET system_estimated_mat_cost =
2131: system_estimated_mat_cost
2132: - (v_est_rec.sys_mat/l_asset_count),
2133: system_estimated_lab_cost =

Line 2165: DELETE from cst_eam_asset_per_balances

2161:
2162: ----------------------------------------------------------------
2163: -- Delete ceapb rows with zeros in ALL value columns
2164: ----------------------------------------------------------------
2165: DELETE from cst_eam_asset_per_balances
2166: WHERE actual_mat_cost = 0 AND
2167: NVL(actual_lab_cost,0) = 0 AND
2168: NVL(actual_eqp_cost,0) = 0 AND
2169: NVL(system_estimated_mat_cost,0) = 0 AND

Line 2203: UPDATE cst_eam_asset_per_balances

2199: (v_est_rec.man_mat <> 0 OR
2200: v_est_rec.man_lab <> 0 OR
2201: v_est_rec.man_eqp <> 0) THEN
2202: l_stmt_num := 314;
2203: UPDATE cst_eam_asset_per_balances
2204: SET manual_estimated_mat_cost =
2205: manual_estimated_mat_cost
2206: - (v_est_rec.man_mat/l_asset_count),
2207: manual_estimated_lab_cost =

Line 2239: DELETE from cst_eam_asset_per_balances

2235:
2236: ----------------------------------------------------------------
2237: -- Delete ceapb rows with zeros in ALL value columns
2238: ----------------------------------------------------------------
2239: DELETE from cst_eam_asset_per_balances
2240: WHERE actual_mat_cost = 0 AND
2241: NVL(actual_lab_cost,0) = 0 AND
2242: NVL(actual_eqp_cost,0) = 0 AND
2243: NVL(system_estimated_mat_cost,0) = 0 AND

Line 2285: UPDATE cst_eam_asset_per_balances

2281: ( v_est_rec.sys_mat <> 0 OR
2282: v_est_rec.sys_lab <> 0 OR
2283: v_est_rec.sys_eqp <> 0) THEN
2284: l_stmt_num := 316;
2285: UPDATE cst_eam_asset_per_balances
2286: SET system_estimated_mat_cost =
2287: system_estimated_mat_cost
2288: - v_est_rec.sys_mat,
2289: system_estimated_lab_cost =

Line 2305: UPDATE cst_eam_asset_per_balances

2301: (v_est_rec.man_mat <> 0 OR
2302: v_est_rec.man_lab <> 0 OR
2303: v_est_rec.man_eqp <> 0) THEN
2304: l_stmt_num := 320;
2305: UPDATE cst_eam_asset_per_balances
2306: SET manual_estimated_mat_cost =
2307: manual_estimated_mat_cost
2308: - v_est_rec.man_mat,
2309: manual_estimated_lab_cost =

Line 2331: DELETE from cst_eam_asset_per_balances

2327: l_stmt_num := 325;
2328: ----------------------------------------------------------------
2329: -- Delete ceapb rows with zeros in ALL value columns
2330: ----------------------------------------------------------------
2331: DELETE from cst_eam_asset_per_balances
2332: WHERE actual_mat_cost = 0 AND
2333: NVL(actual_lab_cost,0) = 0 AND
2334: NVL(actual_eqp_cost,0) = 0 AND
2335: NVL(system_estimated_mat_cost,0) = 0 AND

Line 5374: FROM cst_eam_asset_per_balances ceapb,

5370: sysdate,
5371: 1,
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