APPS.GMF_SUBLEDGER_PKG dependencies on CM_MTHD_MST

Line 46: g_cost_type_code VARCHAR2(40); /* cm_mthd_mst.cost_mthd_code */

42: g_ledger_name VARCHAR2(250);
43: g_process_category VARCHAR2(250);
44:
45: g_cost_type_id NUMBER; /* New cost type terminology */
46: g_cost_type_code VARCHAR2(40); /* cm_mthd_mst.cost_mthd_code */
47: g_cost_method_type NUMBER; /* cm_mthd_mst.cost_type */
48: g_cost_method VARCHAR2(100); /* lkup 'GMF_COST_METHOD' meaning */
49: g_default_cost_type_id NUMBER;
50:

Line 47: g_cost_method_type NUMBER; /* cm_mthd_mst.cost_type */

43: g_process_category VARCHAR2(250);
44:
45: g_cost_type_id NUMBER; /* New cost type terminology */
46: g_cost_type_code VARCHAR2(40); /* cm_mthd_mst.cost_mthd_code */
47: g_cost_method_type NUMBER; /* cm_mthd_mst.cost_type */
48: g_cost_method VARCHAR2(100); /* lkup 'GMF_COST_METHOD' meaning */
49: g_default_cost_type_id NUMBER;
50:
51: g_crev_curr_cost_type_id NUMBER;

Line 194: FROM gl_plcy_mst plcy, cm_mthd_mst mthd

190: /* Start INVCONV umoogala
191: CURSOR c_fiscal_policy(cp_co_code VARCHAR2)
192: IS
193: SELECT NVL(mthd.lot_actual_cost,0)
194: FROM gl_plcy_mst plcy, cm_mthd_mst mthd
195: WHERE plcy.co_code = cp_co_code
196: ;
197: */
198: l_procedure_name CONSTANT VARCHAR2(30) := 'UPDATE_PROCESS';

Line 280: cm_mthd_mst mthd, gem_lookups lk

276: INTO g_legal_entity_name, g_ledger_name,
277: g_cost_method_type, g_cost_type_code, g_cost_method,
278: g_default_cost_type_id
279: FROM org_organization_definitions le, gl_ledgers led,
280: cm_mthd_mst mthd, gem_lookups lk
281: WHERE le.organization_id = g_legal_entity_id
282: AND led.ledger_id = g_ledger_id
283: AND mthd.cost_type_id = g_cost_type_id
284: AND lk.lookup_type = 'GMF_COST_METHOD'

Line 322: FROM cm_mthd_mst mthd,

318: INTO g_cost_method_type,
319: g_cost_type_code,
320: g_cost_method,
321: g_default_cost_type_id
322: FROM cm_mthd_mst mthd,
323: gem_lookups lk
324: WHERE mthd.cost_type_id = g_cost_type_id
325: AND lk.lookup_type = 'GMF_COST_METHOD'
326: AND lk.lookup_code = mthd.cost_type ;

Line 381: FROM gmf_period_statuses curr, gmf_period_statuses prev, cm_mthd_mst mthd

377: SELECT curr.period_id, prev.period_id,
378: mthd.cost_mthd_code
379: INTO g_crev_curr_period_id, g_crev_prev_period_id,
380: g_crev_prev_cost_mthd
381: FROM gmf_period_statuses curr, gmf_period_statuses prev, cm_mthd_mst mthd
382: WHERE curr.legal_entity_id = g_legal_entity_id
383: AND curr.cost_type_id = g_cost_type_id
384: AND curr.calendar_code = g_crev_curr_calendar
385: AND curr.period_code = g_crev_curr_period

Line 1362: (SELECT default_lot_cost_mthd from cm_mthd_mst

1358: g_cost_type_code, /* cost_mthd_code */
1359: g_cost_method_type, /* cost_type */
1360: g_default_cost_type_id,
1361: DECODE(g_default_cost_type_id, NULL, NULL, /* default_lot_cost_mthd */
1362: (SELECT default_lot_cost_mthd from cm_mthd_mst
1363: WHERE cost_type_id = g_default_cost_type_id
1364: AND delete_mark = 0)),
1365: plcy.cost_basis,
1366: 0, /* extract_hdr_rows_posted, */

Line 2000: cm_mthd_mst mthd, gem_lookups lk

1996: INTO g_legal_entity_name, g_ledger_name,
1997: g_cost_method_type, g_cost_type_code, g_cost_method,
1998: g_default_cost_type_id
1999: FROM org_organization_definitions le, gl_ledgers led,
2000: cm_mthd_mst mthd, gem_lookups lk
2001: WHERE le.organization_id = g_legal_entity_id
2002: AND led.ledger_id = g_ledger_id
2003: AND mthd.cost_type_id = g_cost_type_id
2004: AND lk.lookup_type = 'GMF_COST_METHOD'

Line 2042: FROM cm_mthd_mst mthd,

2038: INTO g_cost_method_type,
2039: g_cost_type_code,
2040: g_cost_method,
2041: g_default_cost_type_id
2042: FROM cm_mthd_mst mthd,
2043: gem_lookups lk
2044: WHERE mthd.cost_type_id = g_cost_type_id
2045: AND lk.lookup_type = 'GMF_COST_METHOD'
2046: AND lk.lookup_code = mthd.cost_type ;

Line 2093: FROM gmf_period_statuses curr, gmf_period_statuses prev, cm_mthd_mst mthd

2089: SELECT curr.period_id, prev.period_id,
2090: mthd.cost_mthd_code
2091: INTO g_crev_curr_period_id, g_crev_prev_period_id,
2092: g_crev_prev_cost_mthd
2093: FROM gmf_period_statuses curr, gmf_period_statuses prev, cm_mthd_mst mthd
2094: WHERE curr.legal_entity_id = g_legal_entity_id
2095: AND curr.cost_type_id = g_cost_type_id
2096: AND curr.calendar_code = g_crev_curr_calendar
2097: AND curr.period_code = g_crev_curr_period