DBA Data[Home] [Help]

APPS.MTL_INV_UTIL_GRP dependencies on MTL_PARAMETERS

Line 956: MTL_PARAMETERS P

952: BEGIN
953: SELECT 'x'
954: INTO L_nothing
955: FROM MTL_SERIAL_NUMBERS S,
956: MTL_PARAMETERS P
957: WHERE S.CURRENT_ORGANIZATION_ID = P.ORGANIZATION_ID
958: AND S.SERIAL_NUMBER = P_serial_number
959: AND P.SERIAL_NUMBER_TYPE = 3;
960: IF L_nothing IS NOT NULL then

Line 1062: MTL_PARAMETERS P

1058: BEGIN
1059: SELECT 'x'
1060: INTO L_nothing
1061: FROM MTL_SERIAL_NUMBERS S,
1062: MTL_PARAMETERS P
1063: WHERE S.INVENTORY_ITEM_ID = P_item_id
1064: AND S.CURRENT_ORGANIZATION_ID = P.ORGANIZATION_ID
1065: AND S.SERIAL_NUMBER = P_serial_number
1066: AND P.SERIAL_NUMBER_TYPE = 1;