APPS.GMF_VALIDATIONS_PVT dependencies on MTL_ITEM_FLEXFIELDS

Line 2708: * p_item_number IN mtl_item_flexfields.item_number%TYPE *

2704: * This function validates that the Item Number exists *
2705: * *
2706: * PARAMETERS *
2707: * p_organization_id IN mtl_organizations.organization_id%TYPE *
2708: * p_item_number IN mtl_item_flexfields.item_number%TYPE *
2709: * *
2710: * RETURNS *
2711: * Inventory Item Id *
2712: * *

Line 2718: p_item_number IN mtl_item_flexfields.item_number%TYPE,

2714: * 20-Oct-2005 Anand Thiyagarajan - Created *
2715: ***************************************************************************************/
2716: FUNCTION Validate_item_number
2717: (
2718: p_item_number IN mtl_item_flexfields.item_number%TYPE,
2719: p_organization_id IN mtl_organizations.organization_id%TYPE
2720: )
2721: RETURN NUMBER
2722: IS

Line 2731: FROM mtl_item_flexfields

2727:
2728: CURSOR Cur_item
2729: IS
2730: SELECT inventory_item_id
2731: FROM mtl_item_flexfields
2732: WHERE item_number = p_item_number
2733: AND organization_id = p_organization_id;
2734:
2735: /******************