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_CMCOMMON dependencies on CM_MTHD_MST

Line 481: p_cost_type_id cm_mthd_mst.cost_type_id%type;

477: X_itemcost_id gl_item_cst.itemcost_id%TYPE;
478: X_cost_organization_id cm_whse_asc.cost_organization_id%TYPE;
479: X_no_recs NUMBER(10);
480: i INTEGER;
481: p_cost_type_id cm_mthd_mst.cost_type_id%type;
482: l_cost_type cm_mthd_mst.cost_type%type;
483:
484: /********************************************
485: * Change this only when absolutely required *

Line 482: l_cost_type cm_mthd_mst.cost_type%type;

478: X_cost_organization_id cm_whse_asc.cost_organization_id%TYPE;
479: X_no_recs NUMBER(10);
480: i INTEGER;
481: p_cost_type_id cm_mthd_mst.cost_type_id%type;
482: l_cost_type cm_mthd_mst.cost_type%type;
483:
484: /********************************************
485: * Change this only when absolutely required *
486: ********************************************/

Line 670: FROM cm_mthd_mst

666: v_cost_type_id IN NUMBER
667: )
668: IS
669: SELECT cost_type
670: FROM cm_mthd_mst
671: WHERE cost_type_id = v_cost_type_id;
672:
673:
674:

Line 798: FROM cm_mthd_mst

794: IF (p_cost_method IS NULL) THEN
795: p_cost_type_id := P_cached_cost_type_id;
796: SELECT cost_mthd_code
797: INTO p_cost_method
798: FROM cm_mthd_mst
799: WHERE cost_type_id = P_cached_cost_type_id;
800: ELSE
801: SELECT cost_type_id
802: INTO p_cost_type_id

Line 803: FROM cm_mthd_mst

799: WHERE cost_type_id = P_cached_cost_type_id;
800: ELSE
801: SELECT cost_type_id
802: INTO p_cost_type_id
803: FROM cm_mthd_mst
804: WHERE cost_mthd_code = p_cost_method;
805: END IF;
806:
807: IF l_debug_flag > 0 THEN

Line 1138: l_cost_type_id1 cm_mthd_mst.cost_type_id%type;

1134: i NUMBER;
1135: l_header_id NUMBER;
1136: l_lot_actual_cost NUMBER;
1137: l_avg_cost NUMBER;
1138: l_cost_type_id1 cm_mthd_mst.cost_type_id%type;
1139: l_cost_type cm_mthd_mst.cost_type%type;
1140: l_default_lot_cost_type_id cm_mthd_mst.default_lot_cost_type_id%type;
1141: l_default_cost_mthd_code cm_mthd_mst.cost_mthd_code%TYPE;
1142:

Line 1139: l_cost_type cm_mthd_mst.cost_type%type;

1135: l_header_id NUMBER;
1136: l_lot_actual_cost NUMBER;
1137: l_avg_cost NUMBER;
1138: l_cost_type_id1 cm_mthd_mst.cost_type_id%type;
1139: l_cost_type cm_mthd_mst.cost_type%type;
1140: l_default_lot_cost_type_id cm_mthd_mst.default_lot_cost_type_id%type;
1141: l_default_cost_mthd_code cm_mthd_mst.cost_mthd_code%TYPE;
1142:
1143: ERROR_RETURN_STATUS EXCEPTION;

Line 1140: l_default_lot_cost_type_id cm_mthd_mst.default_lot_cost_type_id%type;

1136: l_lot_actual_cost NUMBER;
1137: l_avg_cost NUMBER;
1138: l_cost_type_id1 cm_mthd_mst.cost_type_id%type;
1139: l_cost_type cm_mthd_mst.cost_type%type;
1140: l_default_lot_cost_type_id cm_mthd_mst.default_lot_cost_type_id%type;
1141: l_default_cost_mthd_code cm_mthd_mst.cost_mthd_code%TYPE;
1142:
1143: ERROR_RETURN_STATUS EXCEPTION;
1144:

Line 1141: l_default_cost_mthd_code cm_mthd_mst.cost_mthd_code%TYPE;

1137: l_avg_cost NUMBER;
1138: l_cost_type_id1 cm_mthd_mst.cost_type_id%type;
1139: l_cost_type cm_mthd_mst.cost_type%type;
1140: l_default_lot_cost_type_id cm_mthd_mst.default_lot_cost_type_id%type;
1141: l_default_cost_mthd_code cm_mthd_mst.cost_mthd_code%TYPE;
1142:
1143: ERROR_RETURN_STATUS EXCEPTION;
1144:
1145: /**********

Line 1157: FROM cm_mthd_mst

1153: IS
1154: SELECT
1155: cost_type,
1156: default_lot_cost_type_id
1157: FROM cm_mthd_mst
1158: WHERE cost_type_id = v_cost_type_id;
1159:
1160: CURSOR Cur_get_cost_mthd ( v_organization_id IN NUMBER ) IS
1161: SELECT m.cost_type_id,

Line 1163: FROM cm_mthd_mst m,

1159:
1160: CURSOR Cur_get_cost_mthd ( v_organization_id IN NUMBER ) IS
1161: SELECT m.cost_type_id,
1162: m.default_lot_cost_type_id
1163: FROM cm_mthd_mst m,
1164: gmf_fiscal_policies plc,
1165: hr_organization_information o
1166: WHERE o.organization_id = v_organization_id
1167: AND o.org_information_context = 'Accounting Information'

Line 1261: FROM cm_mthd_mst

1257:
1258: IF (p_cost_method IS NOT NULL) THEN
1259: SELECT cost_type_id
1260: INTO l_cost_type_id
1261: FROM cm_mthd_mst
1262: WHERE cost_mthd_code = p_cost_method
1263: AND delete_mark = 0;
1264: END IF;
1265:

Line 1421: FROM cm_mthd_mst

1417: -- PK code fix NVL B7213143
1418: IF (l_cost_type = 6 AND l_default_lot_cost_type_id IS NOT NULL AND NVL(x_total_cost, 0) = 0 AND NVL(l_avg_cost, 0) = 0) THEN
1419: BEGIN
1420: SELECT cost_mthd_code INTO l_default_cost_mthd_code
1421: FROM cm_mthd_mst
1422: WHERE cost_type_id = l_default_lot_cost_type_id AND
1423: delete_mark = 0;
1424: EXCEPTION
1425: WHEN OTHERS THEN

Line 1970: x_cost_method cm_mthd_mst.cost_mthd_code%TYPE;

1966: x_msg_count NUMBER;
1967: x_msg_data VARCHAR2(2000);
1968: x_no_of_rows NUMBER;
1969:
1970: x_cost_method cm_mthd_mst.cost_mthd_code%TYPE;
1971: x_cost_component_class_id cm_cmpt_mst.cost_cmpntcls_id%TYPE;
1972: x_cost_analysis_code cm_alys_mst.cost_analysis_code%TYPE;
1973:
1974: BEGIN

Line 2036: l_cost_method CM_MTHD_MST.COST_MTHD_CODE%TYPE;

2032: l_msg_count NUMBER(10);
2033: l_msg_data VARCHAR2(2000);
2034: l_total_cost NUMBER;
2035: l_no_of_rows NUMBER(10);
2036: l_cost_method CM_MTHD_MST.COST_MTHD_CODE%TYPE;
2037: l_cost_component_class_id CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;
2038: l_cost_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;
2039: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Unit_Cost' ;
2040: l_api_version CONSTANT NUMBER := 1.0 ;

Line 2165: l_cost_method CM_MTHD_MST.COST_MTHD_CODE%TYPE;

2161: l_msg_count NUMBER(10);
2162: l_msg_data VARCHAR2(2000);
2163: l_total_cost NUMBER;
2164: l_no_of_rows NUMBER(10);
2165: l_cost_method CM_MTHD_MST.COST_MTHD_CODE%TYPE;
2166: l_cost_component_class_id CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;
2167: l_cost_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;
2168: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Unit_Cost' ;
2169: l_api_version CONSTANT NUMBER := 1.0 ;