APPS.INV_FLEX_LOT_ALLOCATION_PUB dependencies on FND_PRODUCT_GROUPS
Line 38: SELECT RELEASE_NAME INTO L_RELEASE_NAME FROM FND_PRODUCT_GROUPS WHERE ROWNUM = 1;
34:
35: --If apps version is 12.1.x,12.2.0,12.2.1, Then keep original logic(Always Allocate Lot),Return Y
36: --Else(version = 12.2.2 or higher),return actual parameter value
37: BEGIN 38: SELECT RELEASE_NAME INTO L_RELEASE_NAME FROM FND_PRODUCT_GROUPS WHERE ROWNUM = 1; 39: print_debug('RELEASE_NAME:'||L_RELEASE_NAME);
40: EXCEPTION
41: WHEN OTHERS THEN
42: L_RELEASE_NAME := '12.1';