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 485: p_cost_type_id cm_mthd_mst.cost_type_id%type;

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

Line 486: l_cost_type cm_mthd_mst.cost_type%type;

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

Line 674: FROM cm_mthd_mst

670: v_cost_type_id IN NUMBER
671: )
672: IS
673: SELECT cost_type
674: FROM cm_mthd_mst
675: WHERE cost_type_id = v_cost_type_id;
676:
677: -- PK Bug 10370554 INV Valuation report
678: -- ?? What about negative on hands in both the cursors ??

Line 839: FROM cm_mthd_mst

835: IF (p_cost_method IS NULL) THEN
836: p_cost_type_id := P_cached_cost_type_id;
837: SELECT cost_mthd_code
838: INTO p_cost_method
839: FROM cm_mthd_mst
840: WHERE cost_type_id = P_cached_cost_type_id;
841: ELSE
842: SELECT cost_type_id
843: INTO p_cost_type_id

Line 844: FROM cm_mthd_mst

840: WHERE cost_type_id = P_cached_cost_type_id;
841: ELSE
842: SELECT cost_type_id
843: INTO p_cost_type_id
844: FROM cm_mthd_mst
845: WHERE cost_mthd_code = p_cost_method;
846: END IF;
847:
848: IF l_debug_flag > 0 THEN

Line 1310: l_cost_type_id1 cm_mthd_mst.cost_type_id%type;

1306: i NUMBER;
1307: l_header_id NUMBER;
1308: l_lot_actual_cost NUMBER;
1309: l_avg_cost NUMBER;
1310: l_cost_type_id1 cm_mthd_mst.cost_type_id%type;
1311: l_cost_type cm_mthd_mst.cost_type%type;
1312: l_default_lot_cost_type_id cm_mthd_mst.default_lot_cost_type_id%type;
1313: l_default_cost_mthd_code cm_mthd_mst.cost_mthd_code%TYPE;
1314:

Line 1311: l_cost_type cm_mthd_mst.cost_type%type;

1307: l_header_id NUMBER;
1308: l_lot_actual_cost NUMBER;
1309: l_avg_cost NUMBER;
1310: l_cost_type_id1 cm_mthd_mst.cost_type_id%type;
1311: l_cost_type cm_mthd_mst.cost_type%type;
1312: l_default_lot_cost_type_id cm_mthd_mst.default_lot_cost_type_id%type;
1313: l_default_cost_mthd_code cm_mthd_mst.cost_mthd_code%TYPE;
1314:
1315: ERROR_RETURN_STATUS EXCEPTION;

Line 1312: l_default_lot_cost_type_id cm_mthd_mst.default_lot_cost_type_id%type;

1308: l_lot_actual_cost NUMBER;
1309: l_avg_cost NUMBER;
1310: l_cost_type_id1 cm_mthd_mst.cost_type_id%type;
1311: l_cost_type cm_mthd_mst.cost_type%type;
1312: l_default_lot_cost_type_id cm_mthd_mst.default_lot_cost_type_id%type;
1313: l_default_cost_mthd_code cm_mthd_mst.cost_mthd_code%TYPE;
1314:
1315: ERROR_RETURN_STATUS EXCEPTION;
1316:

Line 1313: l_default_cost_mthd_code cm_mthd_mst.cost_mthd_code%TYPE;

1309: l_avg_cost NUMBER;
1310: l_cost_type_id1 cm_mthd_mst.cost_type_id%type;
1311: l_cost_type cm_mthd_mst.cost_type%type;
1312: l_default_lot_cost_type_id cm_mthd_mst.default_lot_cost_type_id%type;
1313: l_default_cost_mthd_code cm_mthd_mst.cost_mthd_code%TYPE;
1314:
1315: ERROR_RETURN_STATUS EXCEPTION;
1316:
1317: /**********

Line 1329: FROM cm_mthd_mst

1325: IS
1326: SELECT
1327: cost_type,
1328: default_lot_cost_type_id
1329: FROM cm_mthd_mst
1330: WHERE cost_type_id = v_cost_type_id;
1331:
1332: CURSOR Cur_get_cost_mthd ( v_organization_id IN NUMBER ) IS
1333: SELECT m.cost_type_id,

Line 1335: FROM cm_mthd_mst m,

1331:
1332: CURSOR Cur_get_cost_mthd ( v_organization_id IN NUMBER ) IS
1333: SELECT m.cost_type_id,
1334: m.default_lot_cost_type_id
1335: FROM cm_mthd_mst m,
1336: gmf_fiscal_policies plc,
1337: hr_organization_information o
1338: WHERE o.organization_id = v_organization_id
1339: AND o.org_information_context = 'Accounting Information'

Line 1433: FROM cm_mthd_mst

1429:
1430: IF (p_cost_method IS NOT NULL) THEN
1431: SELECT cost_type_id
1432: INTO l_cost_type_id
1433: FROM cm_mthd_mst
1434: WHERE cost_mthd_code = p_cost_method
1435: AND delete_mark = 0;
1436: END IF;
1437:

Line 1599: FROM cm_mthd_mst

1595: /* 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 Bug13890277 Commented */
1596: IF (l_cost_type = 6 AND l_default_lot_cost_type_id IS NOT NULL AND x_total_cost IS NULL AND l_avg_cost IS NULL) THEN
1597: BEGIN
1598: SELECT cost_mthd_code INTO l_default_cost_mthd_code
1599: FROM cm_mthd_mst
1600: WHERE cost_type_id = l_default_lot_cost_type_id AND
1601: delete_mark = 0;
1602: EXCEPTION
1603: WHEN OTHERS THEN

Line 2148: x_cost_method cm_mthd_mst.cost_mthd_code%TYPE;

2144: x_msg_count NUMBER;
2145: x_msg_data VARCHAR2(2000);
2146: x_no_of_rows NUMBER;
2147:
2148: x_cost_method cm_mthd_mst.cost_mthd_code%TYPE;
2149: x_cost_component_class_id cm_cmpt_mst.cost_cmpntcls_id%TYPE;
2150: x_cost_analysis_code cm_alys_mst.cost_analysis_code%TYPE;
2151:
2152: BEGIN

Line 2214: l_cost_method CM_MTHD_MST.COST_MTHD_CODE%TYPE;

2210: l_msg_count NUMBER(10);
2211: l_msg_data VARCHAR2(2000);
2212: l_total_cost NUMBER;
2213: l_no_of_rows NUMBER(10);
2214: l_cost_method CM_MTHD_MST.COST_MTHD_CODE%TYPE;
2215: l_cost_component_class_id CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;
2216: l_cost_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;
2217: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Unit_Cost' ;
2218: l_api_version CONSTANT NUMBER := 1.0 ;

Line 2343: l_cost_method CM_MTHD_MST.COST_MTHD_CODE%TYPE;

2339: l_msg_count NUMBER(10);
2340: l_msg_data VARCHAR2(2000);
2341: l_total_cost NUMBER;
2342: l_no_of_rows NUMBER(10);
2343: l_cost_method CM_MTHD_MST.COST_MTHD_CODE%TYPE;
2344: l_cost_component_class_id CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;
2345: l_cost_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;
2346: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Unit_Cost' ;
2347: l_api_version CONSTANT NUMBER := 1.0 ;