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

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 4392: l_item_name mtl_system_items_b.description%TYPE :=p_item_name;

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;
4396: l_item_number_max_length NUMBER :=16;

Line 4393: l_tax_name mtl_system_items_b.attribute1%TYPE :=p_tax_name;

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;
4396: l_item_number_max_length NUMBER :=16;
4397: l_item_name_max_length NUMBER :=60;

Line 4394: l_item_model mtl_system_items_b.attribute1%TYPE :=p_item_model;

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;
4396: l_item_number_max_length NUMBER :=16;
4397: l_item_name_max_length NUMBER :=60;
4398: l_tax_name_max_length NUMBER :=4;

Line 4395: l_uom mtl_system_items_b.primary_unit_of_measure%TYPE :=p_uom;

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;
4396: l_item_number_max_length NUMBER :=16;
4397: l_item_name_max_length NUMBER :=60;
4398: l_tax_name_max_length NUMBER :=4;
4399: l_taxrate_maxlen_before_dot NUMBER :=4;

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 4766: l_item_name mtl_system_items_b.description%TYPE;

4762: l_item_category_to mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_to;
4763: l_creation_date_from DATE;
4764: l_creation_date_to DATE;
4765: l_export_item_count NUMBER;
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;

Line 4768: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;

4764: l_creation_date_to DATE;
4765: l_export_item_count NUMBER;
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;

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 4774: l_tax_name mtl_system_items_b.attribute1%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;
4775: l_item_model mtl_system_items_b.attribute1%TYPE;
4776: l_dbg_msg VARCHAR2(1000);
4777: l_item_status MTL_ITEM_STATUS.INVENTORY_ITEM_STATUS_CODE%TYPE :=p_item_status;
4778:

Line 4775: l_item_model mtl_system_items_b.attribute1%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;
4775: l_item_model mtl_system_items_b.attribute1%TYPE;
4776: l_dbg_msg VARCHAR2(1000);
4777: l_item_status MTL_ITEM_STATUS.INVENTORY_ITEM_STATUS_CODE%TYPE :=p_item_status;
4778:
4779: CURSOR c_item IS

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

Line 4915: mtl_system_items_b

4911: --Yao Zhang add end
4912: ,NULL
4913: )
4914: FROM
4915: mtl_system_items_b
4916: WHERE inventory_item_id=l_inventory_item_id
4917: AND organization_id=l_master_org_id
4918: AND attribute_category=l_item_attribute_category;
4919:

Line 4989: mtl_system_items_b

4985: --Yao Zhang add end
4986: ,NULL
4987: )
4988: FROM
4989: mtl_system_items_b
4990: WHERE inventory_item_id=l_inventory_item_id
4991: AND organization_id=l_master_org_id
4992: AND attribute_category=l_item_attribute_category;
4993: