APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on MTL_CROSS_REFERENCES

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

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

Line 4819: mtl_cross_references reference1

4815: SELECT
4816:
4817: reference1.cross_reference
4818: FROM
4819: mtl_cross_references reference1
4820: WHERE reference1.inventory_item_id=l_inventory_item_id
4821: AND (reference1.organization_id=l_master_org_id OR reference1.organization_id IS NULL)
4822: AND reference1.cross_reference_type=l_cross_reference_type
4823: AND reference1.creation_date=(SELECT

Line 4826: mtl_cross_references reference2

4822: AND reference1.cross_reference_type=l_cross_reference_type
4823: AND reference1.creation_date=(SELECT
4824: MAX(creation_date)
4825: FROM
4826: mtl_cross_references reference2
4827: WHERE reference2.inventory_item_id=l_inventory_item_id
4828: AND (reference2.organization_id=l_master_org_id OR reference2.organization_id IS NULL)
4829: AND reference2.cross_reference_type=l_cross_reference_type
4830: );