[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
BOM_IMPLOSION_TEMP_S.NEXTVAL
INTO L_SEQUENCE_ID
FROM
DUAL;
SELECT
ITEM_NUMBER
INTO L_ITEM_NUMBER
FROM
MTL_ITEM_FLEXFIELDS
WHERE ITEM_ID = P_ITEM_ID
AND ORGANIZATION_ID = LP_ORG_ID;
FOR C1 IN (SELECT
ORGANIZATION_ID
FROM
MTL_PARAMETERS MP
WHERE MASTER_ORGANIZATION_ID = (
SELECT
MASTER_ORGANIZATION_ID
FROM
MTL_PARAMETERS
WHERE ORGANIZATION_ID = LP_ORG_ID )
AND MP.ORGANIZATION_ID IN (
SELECT
ORGANIZATION_ID
FROM
ORG_ACCESS_VIEW
WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')
AND RESP_APPLICATION_ID = FND_PROFILE.VALUE('RESP_APPL_ID') )) LOOP
N := N + 1;
L_STR := 'INSERT INTO BOM_IMPLOSION_TEMP (
SEQUENCE_ID,LOWEST_ITEM_ID,CURRENT_ITEM_ID,PARENT_ITEM_ID,
CURRENT_LEVEL,SORT_CODE,CURRENT_ASSEMBLY_TYPE,
LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,
REQUEST_ID,ORGANIZATION_ID) ';
INSERT INTO BOM_IMPLOSION_TEMP
(SEQUENCE_ID
,LOWEST_ITEM_ID
,CURRENT_ITEM_ID
,PARENT_ITEM_ID
,CURRENT_LEVEL
,SORT_CODE
,CURRENT_ASSEMBLY_TYPE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,REQUEST_ID
,ORGANIZATION_ID)
VALUES (L_SEQUENCE_ID
,P_ITEM_ID
,P_ITEM_ID
,P_ITEM_ID
,0
,L_SORT_CODE
,NULL
,SYSDATE
,1
,SYSDATE
,1
,P_CONC_REQUEST_ID
,LP_ORG_ID);
L_STR := L_STR || 'SELECT /*+ ORDERED */ DISTINCT ' || TO_CHAR(L_SEQUENCE_ID) || ', MSI.INVENTORY_ITEM_ID,MSI.INVENTORY_ITEM_ID,MSI.INVENTORY_ITEM_ID
,0, ' || L_SORT_CODE || ', ' || 'NULL' || ', SYSDATE, 1, SYSDATE, 1,' || TO_CHAR(P_CONC_REQUEST_ID) || ', ' || TO_CHAR(LP_ORG_ID) || ' FROM MTL_SYSTEM_ITEMS MSI,
MTL_ITEM_CATEGORIES MIC,
MTL_CATEGORIES MC
WHERE ' || P_ASS_BETWEEN || '
AND MSI.BOM_ENABLED_FLAG = ''Y''
AND MSI.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = ' || TO_CHAR(LP_ORG_ID) || '
AND MIC.ORGANIZATION_ID = ' || TO_CHAR(LP_ORG_ID) || '
AND MIC.CATEGORY_SET_ID = ' || TO_CHAR(P_SET_ID) || '
AND MIC.CATEGORY_ID = MC.CATEGORY_ID
AND MC.STRUCTURE_ID =
' || TO_CHAR(P_CATEGORY_STRUCTURE_ID) || '
AND ' || P_CAT_BETWEEN;
SELECT
ML.MEANING
INTO STATUS_NAME
FROM
MFG_LOOKUPS ML
WHERE ML.LOOKUP_CODE = 6
AND ML.LOOKUP_TYPE = 'ECG_ECN_STATUS';
SELECT
ML.MEANING
INTO STATUS_NAME
FROM
ENG_REVISED_ITEMS ERI,
MFG_LOOKUPS ML
WHERE ERI.REVISED_ITEM_SEQUENCE_ID = REVISED_ITEM_SEQUENCE_ID
AND ML.LOOKUP_CODE = ERI.STATUS_TYPE
AND ML.LOOKUP_TYPE = 'ECG_ECN_STATUS';
SELECT
ORG.ORGANIZATION_CODE
INTO ORG_CODE
FROM
ORG_ORGANIZATION_DEFINITIONS ORG
WHERE ORG.ORGANIZATION_ID = GET_ORGCODE.ORGANIZATION_ID;