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.GMF_COPY_ITEM_COST dependencies on CM_BRDN_DTL

Line 1143: UPDATE cm_brdn_dtl

1139: ;
1140:
1141: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from acst_led', 1 );
1142:
1143: UPDATE cm_brdn_dtl
1144: SET
1145: cmpntcost_id = NULL
1146: WHERE
1147: cmpntcost_id = l_updins_cc_id

Line 1464: * cmpntcost_id to null in cm_brdn_dtl for the cost parameters passed

1460: * delete_item_costs
1461: *
1462: * DESCRIPTION
1463: * Deletes the child rows from cm_scst_led, cm_acst_led and sets
1464: * cmpntcost_id to null in cm_brdn_dtl for the cost parameters passed
1465: * NOTE: We do not have to worry about rollover_ind here since this procedure
1466: * is not even called if the item is frozen in the target period.
1467: *
1468: * INPUT PARAMETERS

Line 1535: cm_brdn_dtl

1531: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from scst_led', 3 );
1532:
1533: -- Update brdn_dtl
1534: UPDATE
1535: cm_brdn_dtl
1536: SET
1537: cmpntcost_id = NULL
1538: WHERE
1539: cmpntcost_id = r_cc_id.cmpntcost_id

Line 1922: inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,

1918:
1919: IS
1920:
1921: TYPE rectype_brdn_dtl IS RECORD(
1922: inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,
1923: -- item_no mtl_system_items_b_kfv.concatenated_segments%TYPE,
1924: resources cm_brdn_dtl.resources%TYPE,
1925: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
1926: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,

Line 1924: resources cm_brdn_dtl.resources%TYPE,

1920:
1921: TYPE rectype_brdn_dtl IS RECORD(
1922: inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,
1923: -- item_no mtl_system_items_b_kfv.concatenated_segments%TYPE,
1924: resources cm_brdn_dtl.resources%TYPE,
1925: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
1926: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,
1927: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1928: burden_usage cm_brdn_dtl.burden_usage%TYPE,

Line 1925: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,

1921: TYPE rectype_brdn_dtl IS RECORD(
1922: inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,
1923: -- item_no mtl_system_items_b_kfv.concatenated_segments%TYPE,
1924: resources cm_brdn_dtl.resources%TYPE,
1925: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
1926: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,
1927: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1928: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1929: burden_um cm_brdn_dtl.burden_um%TYPE,

Line 1926: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,

1922: inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,
1923: -- item_no mtl_system_items_b_kfv.concatenated_segments%TYPE,
1924: resources cm_brdn_dtl.resources%TYPE,
1925: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
1926: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,
1927: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1928: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1929: burden_um cm_brdn_dtl.burden_um%TYPE,
1930: item_qty cm_brdn_dtl.item_qty%TYPE,

Line 1927: burden_qty cm_brdn_dtl.burden_qty%TYPE,

1923: -- item_no mtl_system_items_b_kfv.concatenated_segments%TYPE,
1924: resources cm_brdn_dtl.resources%TYPE,
1925: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
1926: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,
1927: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1928: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1929: burden_um cm_brdn_dtl.burden_um%TYPE,
1930: item_qty cm_brdn_dtl.item_qty%TYPE,
1931: item_um cm_brdn_dtl.item_um%TYPE,

Line 1928: burden_usage cm_brdn_dtl.burden_usage%TYPE,

1924: resources cm_brdn_dtl.resources%TYPE,
1925: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
1926: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,
1927: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1928: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1929: burden_um cm_brdn_dtl.burden_um%TYPE,
1930: item_qty cm_brdn_dtl.item_qty%TYPE,
1931: item_um cm_brdn_dtl.item_um%TYPE,
1932: burden_factor cm_brdn_dtl.burden_factor%TYPE

Line 1929: burden_um cm_brdn_dtl.burden_um%TYPE,

1925: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
1926: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,
1927: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1928: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1929: burden_um cm_brdn_dtl.burden_um%TYPE,
1930: item_qty cm_brdn_dtl.item_qty%TYPE,
1931: item_um cm_brdn_dtl.item_um%TYPE,
1932: burden_factor cm_brdn_dtl.burden_factor%TYPE
1933: );

Line 1930: item_qty cm_brdn_dtl.item_qty%TYPE,

1926: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,
1927: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1928: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1929: burden_um cm_brdn_dtl.burden_um%TYPE,
1930: item_qty cm_brdn_dtl.item_qty%TYPE,
1931: item_um cm_brdn_dtl.item_um%TYPE,
1932: burden_factor cm_brdn_dtl.burden_factor%TYPE
1933: );
1934: r_brdn_dtl rectype_brdn_dtl;

Line 1931: item_um cm_brdn_dtl.item_um%TYPE,

1927: burden_qty cm_brdn_dtl.burden_qty%TYPE,
1928: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1929: burden_um cm_brdn_dtl.burden_um%TYPE,
1930: item_qty cm_brdn_dtl.item_qty%TYPE,
1931: item_um cm_brdn_dtl.item_um%TYPE,
1932: burden_factor cm_brdn_dtl.burden_factor%TYPE
1933: );
1934: r_brdn_dtl rectype_brdn_dtl;
1935:

Line 1932: burden_factor cm_brdn_dtl.burden_factor%TYPE

1928: burden_usage cm_brdn_dtl.burden_usage%TYPE,
1929: burden_um cm_brdn_dtl.burden_um%TYPE,
1930: item_qty cm_brdn_dtl.item_qty%TYPE,
1931: item_um cm_brdn_dtl.item_um%TYPE,
1932: burden_factor cm_brdn_dtl.burden_factor%TYPE
1933: );
1934: r_brdn_dtl rectype_brdn_dtl;
1935:
1936: TYPE curtyp_brdn_dtl IS REF CURSOR;

Line 2026: ' cm_brdn_dtl bur ' ||

2022: ' bur.item_qty, ' ||
2023: ' bur.item_uom, ' ||
2024: ' bur.burden_factor ' ||
2025: ' FROM ' ||
2026: ' cm_brdn_dtl bur ' ||
2027: ' WHERE ' ||
2028: ' bur.organization_id = :b_organization_id AND ' ||
2029: ' bur.period_id = :b_period_id AND ' ||
2030: ' bur.cost_type_id = :b_cost_type_id '; -- AND ' ||

Line 2318: cm_brdn_dtl

2314: RAISE e_insert_row_b;
2315: END IF;
2316:
2317: UPDATE
2318: cm_brdn_dtl
2319: SET
2320: -- burdenline_id = GEM5_BURDENLINE_ID_S.NEXTVAL,
2321: burden_qty = r_brdn_dtl.burden_qty,
2322: burden_usage = r_brdn_dtl.burden_usage,

Line 2358: cm_brdn_dtl(

2354:
2355: EXCEPTION
2356: WHEN e_insert_row_b THEN
2357: INSERT INTO
2358: cm_brdn_dtl(
2359: burdenline_id,
2360: organization_id,
2361: inventory_item_id,
2362: resources,

Line 2476: ' cm_brdn_dtl bur ' ||

2472: l_sub_qry_b := '';
2473:
2474: l_del_stmt_b :=
2475: ' DELETE FROM ' ||
2476: ' cm_brdn_dtl bur ' ||
2477: ' WHERE ' ||
2478: ' bur.organization_id = :b_organization_id AND ' ||
2479: ' bur.period_id = :b_period_id AND ' ||
2480: ' bur.cost_type_id = :b_cost_type_id AND ' ||