80: ORG_ORGANIZATION_DEFINITIONS O,
81: FND_CURRENCIES FC,
82: MTL_CATEGORY_SETS MCS,
83: MTL_PARAMETERS MP,
84: MFG_LOOKUPS LU1,
85: MFG_LOOKUPS LU2,
86: MFG_LOOKUPS LU3
87: WHERE FC.CURRENCY_CODE = LP_CURRENCY_CODE
88: AND MP.ORGANIZATION_ID = L_IF_OU_NOT_INVORG
81: FND_CURRENCIES FC,
82: MTL_CATEGORY_SETS MCS,
83: MTL_PARAMETERS MP,
84: MFG_LOOKUPS LU1,
85: MFG_LOOKUPS LU2,
86: MFG_LOOKUPS LU3
87: WHERE FC.CURRENCY_CODE = LP_CURRENCY_CODE
88: AND MP.ORGANIZATION_ID = L_IF_OU_NOT_INVORG
89: AND MCS.CATEGORY_SET_ID = P_CATEGORY_SET
82: MTL_CATEGORY_SETS MCS,
83: MTL_PARAMETERS MP,
84: MFG_LOOKUPS LU1,
85: MFG_LOOKUPS LU2,
86: MFG_LOOKUPS LU3
87: WHERE FC.CURRENCY_CODE = LP_CURRENCY_CODE
88: AND MP.ORGANIZATION_ID = L_IF_OU_NOT_INVORG
89: AND MCS.CATEGORY_SET_ID = P_CATEGORY_SET
90: AND O.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
135: SELECT
136: MEANING
137: INTO P_CONFIG_ITEM_DTLS_OPTS
138: FROM
139: MFG_LOOKUPS
140: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
141: AND LOOKUP_CODE = NVL(P_CONFIG_ITEM_DETAILS
142: ,2);
143: