DBA Data[Home] [Help]

APPS.GMF_LOT_COSTING_PUB dependencies on MTL_CATEGORIES

Line 375: --l_cost_class mtl_categories_v.category_concat_segs%TYPE;

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:
378:
379: --l_item_no VARCHAR2(800);

Line 376: l_cost_category_id mtl_categories_v.category_id%TYPE;

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:
378:
379: --l_item_no VARCHAR2(800);
380: l_lot_no mtl_lot_numbers.LOT_NUMBER%TYPE; /* INVCONV sschinch */

Line 8565: mtl_categories mc

8561: INTO l_cost_category_id
8562: FROM mtl_default_category_sets mdc,
8563: mtl_category_sets mcs,
8564: mtl_item_categories mic,
8565: mtl_categories mc
8566: WHERE mic.inventory_item_id = l_item_id
8567: AND mic.organization_id = l_orgn_id
8568: AND mic.category_id = mc.category_id
8569: AND mcs.structure_id = mc.structure_id