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

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

4387: ,p_item_model IN VARCHAR2
4388: ,p_uom IN VARCHAR2
4389: ) RETURN BOOLEAN
4390: IS
4391: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_number;
4392: l_item_name mtl_system_items_b.description%TYPE :=p_item_name;
4393: l_tax_name mtl_system_items_b.attribute1%TYPE :=p_tax_name;
4394: l_item_model mtl_system_items_b.attribute1%TYPE :=p_item_model;
4395: l_uom mtl_system_items_b.primary_unit_of_measure%TYPE :=p_uom;

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

4753: )
4754: IS
4755: l_org_id NUMBER :=p_org_id;
4756: l_master_org_id NUMBER :=p_master_org_id;
4757: l_item_num_from mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_from;
4758: l_item_num_to mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_to;
4759: l_category_set_id mtl_category_sets_b.category_set_id%TYPE :=p_category_set_id;
4760: l_structure_id mtl_category_sets_b.structure_id%TYPE :=p_category_structure_id;
4761: l_item_category_from mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_from;

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

4754: IS
4755: l_org_id NUMBER :=p_org_id;
4756: l_master_org_id NUMBER :=p_master_org_id;
4757: l_item_num_from mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_from;
4758: l_item_num_to mtl_system_items_b_kfv.concatenated_segments%TYPE :=p_item_num_to;
4759: l_category_set_id mtl_category_sets_b.category_set_id%TYPE :=p_category_set_id;
4760: l_structure_id mtl_category_sets_b.structure_id%TYPE :=p_category_structure_id;
4761: l_item_category_from mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_from;
4762: l_item_category_to mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_to;

Line 4770: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;

4766: l_item_name mtl_system_items_b.description%TYPE;
4767: l_item_name_source VARCHAR2(30) :=p_item_name_source;
4768: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
4769: l_cross_reference_type mtl_cross_references.cross_reference_type%TYPE :=p_cross_reference_type;
4770: l_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
4771: l_item_attribute_category fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
4772: l_tax_name_column fnd_descr_flex_column_usages.application_column_name%TYPE;
4773: l_item_model_column fnd_descr_flex_column_usages.application_column_name%TYPE;
4774: l_tax_name mtl_system_items_b.attribute1%TYPE;

Line 4788: mtl_system_items_b_kfv items

4784: ,items.DESCRIPTION item_name
4785: --,items.primary_unit_of_measure uom Yao Zhang comment for bug 8339490
4786: ,muom.unit_of_measure_tl uom
4787: FROM
4788: mtl_system_items_b_kfv items
4789: ,mtl_item_categories mic
4790: ,mtl_category_sets_b mcs
4791: ,mtl_categories_b_kfv mc
4792: ,mtl_units_of_measure_tl muom --yao zhang add for bug 8339490