[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
RPT_SELECTION VARCHAR2(80);
IF (P_RPT_SELECTION = 1) AND (P_ITEM IS NULL) THEN
FND_MESSAGE.SET_NAME('null'
,'MFG_REQUIRED_VALUE');
SELECT
ITEM_NUMBER
INTO SPECIFIC_ITEM
FROM
MTL_ITEM_FLEXFIELDS
WHERE ORGANIZATION_ID = P_ORG_ID
AND ITEM_ID = P_ITEM;
SELECT
ORG.ORGANIZATION_NAME,
LU1.MEANING,
LU2.MEANING,
LU3.MEANING,
LU4.MEANING,
SETS.CATEGORY_SET_NAME,
BOOKS.CURRENCY_CODE,
LU5.MEANING
INTO ORG_NAME,DISPLAY_OPTION,ALT_OPTION,RPT_SELECTION,DETAIL,CAT_SET_NAME,CURRENCY_CODE,DTL_SUM_CHAR
FROM
ORG_ORGANIZATION_DEFINITIONS ORG,
MFG_LOOKUPS LU1,
MFG_LOOKUPS LU2,
MFG_LOOKUPS LU3,
MFG_LOOKUPS LU4,
MFG_LOOKUPS LU5,
MTL_CATEGORY_SETS SETS,
GL_SETS_OF_BOOKS BOOKS
WHERE ORG.ORGANIZATION_ID = P_ORG_ID
AND LU1.LOOKUP_CODE = P_DISPLAY_OPTION
AND LU1.LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE'
AND LU2.LOOKUP_CODE = P_ALT_OPTION
AND LU2.LOOKUP_TYPE = 'MCG_AUTOLOAD_OPTION'
AND LU3.LOOKUP_CODE = P_RPT_SELECTION
AND LU3.LOOKUP_TYPE = 'BOM_SELECTION_TYPE'
AND LU4.LOOKUP_CODE = P_DETAIL
AND LU4.LOOKUP_TYPE = 'SYS_YES_NO'
AND SETS.CATEGORY_SET_ID = P_CAT_SET
AND ORG.SET_OF_BOOKS_ID = BOOKS.SET_OF_BOOKS_ID
AND LU5.LOOKUP_CODE = P_DETAIL
AND LU5.LOOKUP_TYPE = 'CST_RPT_DETAIL_OPTION';
P_RPT_SELECTION_CHAR := RPT_SELECTION;
IF P_RPT_SELECTION = 2 THEN
IF (P_ITEM_FROM IS NOT NULL) THEN
IF (P_ITEM_TO IS NOT NULL) THEN
NULL;