APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on MTL_CROSS_REFERENCES

Line 4227: l_cross_reference_type mtl_cross_references.cross_reference_type%TYPE :=p_cross_reference_type;

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;
4231: l_item_model_column fnd_descr_flex_column_usages.application_column_name%TYPE;

Line 4271: mtl_cross_references reference1

4267: SELECT
4268:
4269: reference1.cross_reference
4270: FROM
4271: mtl_cross_references reference1
4272: WHERE reference1.inventory_item_id=l_inventory_item_id
4273: AND (reference1.organization_id=l_master_org_id OR reference1.organization_id IS NULL)
4274: AND reference1.cross_reference_type=l_cross_reference_type
4275: AND reference1.creation_date=(SELECT

Line 4278: mtl_cross_references reference2

4274: AND reference1.cross_reference_type=l_cross_reference_type
4275: AND reference1.creation_date=(SELECT
4276: MAX(creation_date)
4277: FROM
4278: mtl_cross_references reference2
4279: WHERE reference2.inventory_item_id=l_inventory_item_id
4280: AND (reference2.organization_id=l_master_org_id OR reference2.organization_id IS NULL)
4281: AND reference2.cross_reference_type=l_cross_reference_type
4282: );