1068: IF l_restrict_sub_code = 1 THEN
1069: DECLARE
1070: l_restricted_sub VARCHAR2(10);
1071:
1072: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1073: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1074: BEGIN
1075: select secondary_inventory into l_restricted_sub
1076: from mtl_item_sub_inventories
1069: DECLARE
1070: l_restricted_sub VARCHAR2(10);
1071:
1072: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1073: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1074: BEGIN
1075: select secondary_inventory into l_restricted_sub
1076: from mtl_item_sub_inventories
1077: where organization_id = p_organization_id