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

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

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

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

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

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

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;
3856: l_item_number_max_length NUMBER :=16;
3857: l_item_name_max_length NUMBER :=60;
3858: l_tax_name_max_length NUMBER :=4;

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

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;
3856: l_item_number_max_length NUMBER :=16;
3857: l_item_name_max_length NUMBER :=60;
3858: l_tax_name_max_length NUMBER :=4;
3859: l_taxrate_maxlen_before_dot NUMBER :=4;

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

4220: l_item_category_to mtl_categories_b_kfv.concatenated_segments%TYPE :=p_item_category_to;
4221: l_creation_date_from DATE;
4222: l_creation_date_to DATE;
4223: l_export_item_count NUMBER;
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;

Line 4226: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;

4222: l_creation_date_to DATE;
4223: l_export_item_count NUMBER;
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;

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 4232: l_tax_name mtl_system_items_b.attribute1%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;
4233: l_item_model mtl_system_items_b.attribute1%TYPE;
4234: l_dbg_msg VARCHAR2(1000);
4235: l_item_status MTL_ITEM_STATUS.INVENTORY_ITEM_STATUS_CODE%TYPE :=p_item_status;
4236:

Line 4233: l_item_model mtl_system_items_b.attribute1%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;
4233: l_item_model mtl_system_items_b.attribute1%TYPE;
4234: l_dbg_msg VARCHAR2(1000);
4235: l_item_status MTL_ITEM_STATUS.INVENTORY_ITEM_STATUS_CODE%TYPE :=p_item_status;
4236:
4237: CURSOR c_item IS

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

Line 4335: mtl_system_items_b

4331: ,ATTRIBUTE15
4332: ,NULL
4333: )
4334: FROM
4335: mtl_system_items_b
4336: WHERE inventory_item_id=l_inventory_item_id
4337: AND organization_id=l_master_org_id
4338: AND attribute_category=l_item_attribute_category;
4339:

Line 4377: mtl_system_items_b

4373: ,ATTRIBUTE15
4374: ,NULL
4375: )
4376: FROM
4377: mtl_system_items_b
4378: WHERE inventory_item_id=l_inventory_item_id
4379: AND organization_id=l_master_org_id
4380: AND attribute_category=l_item_attribute_category;
4381: