APPS.JMF_GTA_ARTRX_PROC dependencies on MTL_CROSS_REFERENCES

Line 1998: l_cross_reference MTL_CROSS_REFERENCES_B.cross_reference%TYPE;

1994: l_inv_tax_attribute_column jmf_gta_system_parameters_all.Inv_Tax_Attribute_Column%TYPE;
1995: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1996: l_cross_rows NUMBER;
1997: --29-JUN-2006 Updated by shujuan
1998: l_cross_reference MTL_CROSS_REFERENCES_B.cross_reference%TYPE;
1999: l_sales_list_flag VARCHAR2(1);
2000: -- 20-JUL-2006 Shujuan Added length from 60 to 240 for bug 5400805
2001: l_inventory_item_name mtl_system_items_b.description%TYPE;
2002: l_inventory_attribute_category mtl_system_items_b.attribute_category%TYPE;

Line 3351: FROM MTL_CROSS_REFERENCES

3347: --yao zhang add end for bug
3348: --get record number in cross reference. Only retrive item cross reference on master inv org
3349: SELECT COUNT(*)
3350: INTO l_cross_rows
3351: FROM MTL_CROSS_REFERENCES
3352: WHERE (organization_id IS NULL OR
3353: organization_id = l_master_org)--yao zhang modified for bug 7721035
3354: AND inventory_item_id = l_inventory_item_id
3355: AND cross_reference_type = l_cross_reference_type;

Line 3361: FROM MTL_CROSS_REFERENCES

3357: --get latest cross reference
3358: IF l_cross_rows > 0 THEN
3359: SELECT MAX(cross_reference)
3360: INTO l_cross_reference
3361: FROM MTL_CROSS_REFERENCES
3362: WHERE (organization_id IS NULL OR
3363: organization_id = l_master_org)--yao zhang modified for bug 7721035
3364: AND inventory_item_id = l_inventory_item_id
3365: AND cross_reference_type = l_cross_reference_type

Line 3368: FROM MTL_CROSS_REFERENCES

3364: AND inventory_item_id = l_inventory_item_id
3365: AND cross_reference_type = l_cross_reference_type
3366: AND last_update_date =
3367: (SELECT MAX(last_update_date)
3368: FROM MTL_CROSS_REFERENCES
3369: WHERE (organization_id IS NULL OR
3370: organization_id = l_master_org)--yao zhang modified for bug 7721035
3371: AND inventory_item_id = l_inventory_item_id
3372: AND cross_reference_type =