DBA Data[Home] [Help]

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 452: l_cost_method_code cm_mthd_mst.cost_mthd_code%TYPE;

448: l_cost_type_id NUMBER;
449:
450: --Use this to get the costof non-lot controlled items
451: l_default_lot_cstype_id NUMBER;
452: l_cost_method_code cm_mthd_mst.cost_mthd_code%TYPE;
453: l_trans_start_date cm_mthd_mst.trans_start_date%TYPE;
454:
455: --l_cost_class mtl_categories_v.category_concat_segs%TYPE;
456: l_cost_category_id mtl_categories_v.category_id%TYPE;

Line 453: l_trans_start_date cm_mthd_mst.trans_start_date%TYPE;

449:
450: --Use this to get the costof non-lot controlled items
451: l_default_lot_cstype_id NUMBER;
452: l_cost_method_code cm_mthd_mst.cost_mthd_code%TYPE;
453: l_trans_start_date cm_mthd_mst.trans_start_date%TYPE;
454:
455: --l_cost_class mtl_categories_v.category_concat_segs%TYPE;
456: l_cost_category_id mtl_categories_v.category_id%TYPE;
457:

Line 586: l_cost_mthd_code cm_mthd_mst.cost_mthd_code%type;

582:
583: TYPE org_tab IS TABLE OF VARCHAR2(4) INDEX BY BINARY_INTEGER;
584: l_org_tab org_tab;
585:
586: l_cost_mthd_code cm_mthd_mst.cost_mthd_code%type;
587: l_default_cost_mthd cm_mthd_mst.cost_mthd_code%type;
588:
589: l_step_lev num_tab;
590: l_step_tab SYSTEM.gmf_step_tab;

Line 587: l_default_cost_mthd cm_mthd_mst.cost_mthd_code%type;

583: TYPE org_tab IS TABLE OF VARCHAR2(4) INDEX BY BINARY_INTEGER;
584: l_org_tab org_tab;
585:
586: l_cost_mthd_code cm_mthd_mst.cost_mthd_code%type;
587: l_default_cost_mthd cm_mthd_mst.cost_mthd_code%type;
588:
589: l_step_lev num_tab;
590: l_step_tab SYSTEM.gmf_step_tab;
591: l_skip_this_batch BOOLEAN ;

Line 10110: FROM cm_mthd_mst m1,

10106: INTO l_default_cost_type_id,
10107: l_trans_start_date,
10108: l_cost_mthd_code,
10109: l_default_cost_mthd
10110: FROM cm_mthd_mst m1,
10111: cm_mthd_mst m2
10112: WHERE m1.cost_type_id = l_cost_type_id
10113: AND m2.cost_type_id = m1.default_lot_cost_type_id;
10114:

Line 10111: cm_mthd_mst m2

10107: l_trans_start_date,
10108: l_cost_mthd_code,
10109: l_default_cost_mthd
10110: FROM cm_mthd_mst m1,
10111: cm_mthd_mst m2
10112: WHERE m1.cost_type_id = l_cost_type_id
10113: AND m2.cost_type_id = m1.default_lot_cost_type_id;
10114:
10115: /******** Bug 4038722 - Dinesh Vadivel - Start **********/