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.JMF_GTA_TXT_OPERATOR_PROC dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 3851: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_number;

3847: ,p_item_model IN VARCHAR2
3848: ,p_uom IN VARCHAR2
3849: ) RETURN BOOLEAN
3850: IS
3851: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_number;
3852: l_item_name mtl_system_items_b.description%TYPE :=p_item_name;
3853: l_tax_name mtl_system_items_b.attribute1%TYPE :=p_tax_name;
3854: l_item_model mtl_system_items_b.attribute1%TYPE :=p_item_model;
3855: l_uom mtl_system_items_b.primary_unit_of_measure%TYPE :=p_uom;

Line 4215: l_item_num_from mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_from;

4211: )
4212: IS
4213: l_org_id NUMBER :=p_org_id;
4214: l_master_org_id NUMBER :=p_master_org_id;
4215: l_item_num_from mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_from;
4216: l_item_num_to mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_to;
4217: l_category_set_id mtl_category_sets_b.category_set_id%TYPE :=p_category_set_id;
4218: l_structure_id mtl_category_sets_b.structure_id%TYPE :=p_category_structure_id;
4219: l_item_category_from mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_from;

Line 4216: l_item_num_to mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_to;

4212: IS
4213: l_org_id NUMBER :=p_org_id;
4214: l_master_org_id NUMBER :=p_master_org_id;
4215: l_item_num_from mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_from;
4216: l_item_num_to mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_to;
4217: l_category_set_id mtl_category_sets_b.category_set_id%TYPE :=p_category_set_id;
4218: l_structure_id mtl_category_sets_b.structure_id%TYPE :=p_category_structure_id;
4219: l_item_category_from mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_from;
4220: l_item_category_to mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_to;

Line 4228: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;

4224: l_item_name mtl_system_items_b.description%TYPE;
4225: l_item_name_source VARCHAR2(30) :=p_item_name_source;
4226: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
4227: l_cross_reference_type mtl_cross_references.cross_reference_type%TYPE :=p_cross_reference_type;
4228: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
4229: l_item_attribute_category fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
4230: l_tax_name_column fnd_descr_flex_column_usages.application_column_name%TYPE;
4231: l_item_model_column fnd_descr_flex_column_usages.application_column_name%TYPE;
4232: l_tax_name mtl_system_items_b.attribute1%TYPE;

Line 4245: mtl_system_items_b_kfv items

4241: ,items.concatenated_segments item_number
4242: ,items.DESCRIPTION item_name
4243: ,items.primary_unit_of_measure uom
4244: FROM
4245: mtl_system_items_b_kfv items
4246: ,mtl_item_categories mic
4247: ,mtl_category_sets_b mcs
4248: ,mtl_categories_b_kfv mc
4249: WHERE items.organization_id=l_master_org_id