APPS.GMF_VALIDATIONS_PVT dependencies on MTL_ITEM_FLEXFIELDS

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

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

Line 2716: p_item_number IN mtl_item_flexfields.item_number%TYPE,

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

Line 2729: FROM mtl_item_flexfields

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