APPS.AR_GTA_ARTRX_PROC dependencies on MTL_CROSS_REFERENCES

Line 2054: l_cross_reference MTL_CROSS_REFERENCES_B.cross_reference%TYPE;

2050: l_inv_tax_attribute_column ar_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;
2051: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2052: l_cross_rows NUMBER;
2053: --29-JUN-2006 Updated by shujuan
2054: l_cross_reference MTL_CROSS_REFERENCES_B.cross_reference%TYPE;
2055: l_sales_list_flag VARCHAR2(1);
2056: -- 20-JUL-2006 Shujuan Added length from 60 to 240 for bug 5400805
2057: l_inventory_item_name mtl_system_items_b.description%TYPE;
2058: l_inventory_attribute_category mtl_system_items_b.attribute_category%TYPE;

Line 3705: FROM MTL_CROSS_REFERENCES

3701: --yao zhang add end for bug 7721035
3702: --get record number in cross reference. Only retrive item cross reference on master inv org
3703: SELECT COUNT(*)
3704: INTO l_cross_rows
3705: FROM MTL_CROSS_REFERENCES
3706: WHERE (organization_id IS NULL OR
3707: organization_id = l_master_org) --yao zhang modified for bug 7721035
3708: AND inventory_item_id = l_inventory_item_id
3709: AND cross_reference_type = l_cross_reference_type;

Line 3715: FROM MTL_CROSS_REFERENCES

3711: --get latest cross reference
3712: IF l_cross_rows > 0 THEN
3713: SELECT MAX(cross_reference)
3714: INTO l_cross_reference
3715: FROM MTL_CROSS_REFERENCES
3716: WHERE (organization_id IS NULL OR
3717: organization_id = l_master_org) --yao zhang modified for bug 7721035
3718: AND inventory_item_id = l_inventory_item_id
3719: AND cross_reference_type = l_cross_reference_type

Line 3722: FROM MTL_CROSS_REFERENCES

3718: AND inventory_item_id = l_inventory_item_id
3719: AND cross_reference_type = l_cross_reference_type
3720: AND last_update_date =
3721: (SELECT MAX(last_update_date)
3722: FROM MTL_CROSS_REFERENCES
3723: WHERE (organization_id IS NULL OR
3724: organization_id = l_master_org) --yao zhang modified for bug 7721035
3725: AND inventory_item_id = l_inventory_item_id
3726: AND cross_reference_type =