APPS.GMF_LOT_COSTING_PUB dependencies on CM_MTHD_MST

Line 73: --* Also, using cm_mthd_mst.default_lot_cost_mthd for non-lot controlled items*

69: --* Called new function is_item_lot_costed to do this in material_cursor. *
70: --* *
71: --* 30-Nov-2003 umoogala Now passing co_code to main routines ROLLUP_LOT_COSTS and removed *
72: --* calendar_code and user params. Using co_code where ever cldr was used. *
73: --* Also, using cm_mthd_mst.default_lot_cost_mthd for non-lot controlled items*
74: --* *
75: --* 03-Dec-2003 PJS Moved the code that sets the inventory transaction as 'costed' to after *
76: --* the main CASE statement, and made it conditional on the return status of *
77: --* whatever procedure was called. *

Line 372: l_cost_method_code cm_mthd_mst.cost_mthd_code%TYPE;

368: l_cost_type_id NUMBER;
369:
370: --Use this to get the costof non-lot controlled items
371: l_default_lot_cstype_id NUMBER;
372: l_cost_method_code cm_mthd_mst.cost_mthd_code%TYPE;
373: l_trans_start_date cm_mthd_mst.trans_start_date%TYPE;
374:
375: --l_cost_class mtl_categories_v.category_concat_segs%TYPE;
376: l_cost_category_id mtl_categories_v.category_id%TYPE;

Line 373: l_trans_start_date cm_mthd_mst.trans_start_date%TYPE;

369:
370: --Use this to get the costof non-lot controlled items
371: l_default_lot_cstype_id NUMBER;
372: l_cost_method_code cm_mthd_mst.cost_mthd_code%TYPE;
373: l_trans_start_date cm_mthd_mst.trans_start_date%TYPE;
374:
375: --l_cost_class mtl_categories_v.category_concat_segs%TYPE;
376: l_cost_category_id mtl_categories_v.category_id%TYPE;
377:

Line 445: l_cost_mthd_code cm_mthd_mst.cost_mthd_code%type;

441: TYPE char_tab IS TABLE OF VARCHAR2(80) INDEX BY VARCHAR2(80); /* INVCONV sschinch */
442:
443: TYPE org_tab IS TABLE OF VARCHAR2(4) INDEX BY BINARY_INTEGER; /* INVCONV sschinch */
444: l_org_tab org_tab; /* INVCONV sschinch */
445: l_cost_mthd_code cm_mthd_mst.cost_mthd_code%type;
446: l_default_cost_mthd cm_mthd_mst.cost_mthd_code%type;
447:
448: l_step_lev num_tab;
449: l_step_tab SYSTEM.gmf_step_tab;

Line 446: l_default_cost_mthd cm_mthd_mst.cost_mthd_code%type;

442:
443: TYPE org_tab IS TABLE OF VARCHAR2(4) INDEX BY BINARY_INTEGER; /* INVCONV sschinch */
444: l_org_tab org_tab; /* INVCONV sschinch */
445: l_cost_mthd_code cm_mthd_mst.cost_mthd_code%type;
446: l_default_cost_mthd cm_mthd_mst.cost_mthd_code%type;
447:
448: l_step_lev num_tab;
449: l_step_tab SYSTEM.gmf_step_tab;
450: l_skip_this_batch BOOLEAN ;

Line 8459: FROM cm_mthd_mst m1,

8455: INTO l_default_cost_type_id,
8456: l_trans_start_date,
8457: l_cost_mthd_code,
8458: l_default_cost_mthd
8459: FROM cm_mthd_mst m1,
8460: cm_mthd_mst m2
8461: WHERE m1.cost_type_id = l_cost_type_id
8462: AND m2.cost_type_id = m1.default_lot_cost_type_id;
8463:

Line 8460: cm_mthd_mst m2

8456: l_trans_start_date,
8457: l_cost_mthd_code,
8458: l_default_cost_mthd
8459: FROM cm_mthd_mst m1,
8460: cm_mthd_mst m2
8461: WHERE m1.cost_type_id = l_cost_type_id
8462: AND m2.cost_type_id = m1.default_lot_cost_type_id;
8463:
8464: