[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NVL(COUNT(*), 0) NUM_CHILDREN
FROM AHL_MC_RELATIONSHIPS
WHERE PARENT_RELATIONSHIP_ID = p_rel_id;
SELECT 'x'
FROM AHL_MC_CONFIG_RELATIONS
WHERE RELATIONSHIP_ID = p_relationship_id;
SELECT RELATIONSHIP_ID,
ACTIVE_END_DATE
FROM AHL_MC_RELATIONSHIPS
WHERE MC_HEADER_ID = p_mc_header_id AND
PARENT_RELATIONSHIP_ID IS NULL;
SELECT NVL(path_position_id, 0)
FROM ahl_mc_path_positions
WHERE encoded_path_position = p_position_path;
SELECT REL.RELATIONSHIP_ID,
REL.OBJECT_VERSION_NUMBER,
REL.POSITION_KEY,
REL.PARENT_RELATIONSHIP_ID,
REL.ITEM_GROUP_ID,
REL.POSITION_REF_CODE,
FPRC.MEANING POSITION_REF_MEANING,
REL.ATA_CODE,
FATA.MEANING ATA_MEANING,
REL.POSITION_NECESSITY_CODE,
FPNC.MEANING POSITION_NECESSITY_MEANING,
REL.UOM_CODE,
REL.QUANTITY,
REL.DISPLAY_ORDER,
REL.ACTIVE_START_DATE,
REL.ACTIVE_END_DATE,
REL.MC_HEADER_ID,
HDR.MC_ID,
HDR.VERSION_NUMBER,
HDR.CONFIG_STATUS_CODE
FROM AHL_MC_RELATIONSHIPS REL,
(
SELECT MCB.MC_HEADER_ID,
MCB.MC_ID,
MCB.VERSION_NUMBER,
DECODE (MCB.CONFIG_STATUS_CODE,
'CLOSED', MCB.CONFIG_STATUS_CODE,
DECODE (SIGN(TRUNC(NVL(MCR.ACTIVE_END_DATE, SYSDATE+1)) - TRUNC(SYSDATE)),
1, MCB.CONFIG_STATUS_CODE, 'EXPIRED')) CONFIG_STATUS_CODE
FROM AHL_MC_HEADERS_B MCB, AHL_MC_RELATIONSHIPS MCR
WHERE MCB.MC_HEADER_ID = MCR.MC_HEADER_ID
AND MCR.PARENT_RELATIONSHIP_ID IS NULL
) HDR,
FND_LOOKUP_VALUES FPRC,
FND_LOOKUP_VALUES FPNC,
FND_LOOKUP_VALUES FATA
WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_relationship_id,0)
AND REL.MC_HEADER_ID = p_mc_header_id
AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
AND TRUNC(NVL(REL.ACTIVE_END_DATE, SYSDATE + 1)) > TRUNC(SYSDATE)
AND FPRC.LOOKUP_CODE (+) = REL.POSITION_REF_CODE
AND FPRC.LOOKUP_TYPE (+) = 'AHL_POSITION_REFERENCE'
AND FPRC.LANGUAGE (+) = USERENV('LANG')
AND FPRC.VIEW_APPLICATION_ID (+) = 0
AND FPNC.LOOKUP_CODE (+) = REL.POSITION_NECESSITY_CODE
AND FPNC.LOOKUP_TYPE (+) = 'AHL_POSITION_NECESSITY'
AND FPNC.LANGUAGE (+) = USERENV('LANG')
AND FPNC.VIEW_APPLICATION_ID (+) = 0
AND FATA.LOOKUP_CODE (+) = REL.ATA_CODE
AND FATA.LOOKUP_TYPE (+) = 'AHL_ATA_CODE'
AND FATA.LANGUAGE (+) = USERENV('LANG')
AND FATA.VIEW_APPLICATION_ID (+) = 0
ORDER BY DISPLAY_ORDER;
SELECT REL.RELATIONSHIP_ID,
REL.OBJECT_VERSION_NUMBER,
REL.POSITION_KEY,
REL.PARENT_RELATIONSHIP_ID,
REL.ITEM_GROUP_ID,
REL.POSITION_REF_CODE,
FPRC.MEANING POSITION_REF_MEANING,
REL.ATA_CODE,
FATA.MEANING ATA_MEANING,
REL.POSITION_NECESSITY_CODE,
FPNC.MEANING POSITION_NECESSITY_MEANING,
REL.UOM_CODE,
REL.QUANTITY,
REL.DISPLAY_ORDER,
REL.ACTIVE_START_DATE,
REL.ACTIVE_END_DATE,
REL.MC_HEADER_ID,
HDR.MC_ID,
HDR.VERSION_NUMBER,
DECODE (HDR.CONFIG_STATUS_CODE,
'CLOSED', HDR.CONFIG_STATUS_CODE,
DECODE (SIGN(TRUNC(NVL(REL.ACTIVE_END_DATE, SYSDATE+1)) - TRUNC(SYSDATE)),
1, HDR.CONFIG_STATUS_CODE, 'EXPIRED')) CONFIG_STATUS_CODE
FROM AHL_MC_RELATIONSHIPS REL,
AHL_MC_HEADERS_B HDR,
FND_LOOKUP_VALUES FPRC,
FND_LOOKUP_VALUES FPNC,
FND_LOOKUP_VALUES FATA
WHERE REL.PARENT_RELATIONSHIP_ID IS NULL
AND REL.MC_HEADER_ID = p_mc_header_id
AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
AND FPRC.LOOKUP_CODE (+) = REL.POSITION_REF_CODE
AND FPRC.LOOKUP_TYPE (+) = 'AHL_POSITION_REFERENCE'
AND FPRC.LANGUAGE (+) = USERENV('LANG')
AND FPRC.VIEW_APPLICATION_ID (+) = 0
AND FPNC.LOOKUP_CODE (+) = REL.POSITION_NECESSITY_CODE
AND FPNC.LOOKUP_TYPE (+) = 'AHL_POSITION_NECESSITY'
AND FPNC.LANGUAGE (+) = USERENV('LANG')
AND FPNC.VIEW_APPLICATION_ID (+) = 0
AND FATA.LOOKUP_CODE (+) = REL.ATA_CODE
AND FATA.LOOKUP_TYPE (+) = 'AHL_ATA_CODE'
AND FATA.LANGUAGE (+) = USERENV('LANG')
AND FATA.VIEW_APPLICATION_ID (+) = 0
ORDER BY DISPLAY_ORDER;
SELECT REL.RELATIONSHIP_ID,
REL.OBJECT_VERSION_NUMBER,
REL.POSITION_KEY,
REL.PARENT_RELATIONSHIP_ID,
REL.ITEM_GROUP_ID,
REL.POSITION_REF_CODE,
FPRC.MEANING POSITION_REF_MEANING,
REL.ATA_CODE,
FATA.MEANING ATA_MEANING,
REL.POSITION_NECESSITY_CODE,
FPNC.MEANING POSITION_NECESSITY_MEANING,
REL.UOM_CODE,
REL.QUANTITY,
REL.DISPLAY_ORDER,
REL.ACTIVE_START_DATE,
REL.ACTIVE_END_DATE,
REL.MC_HEADER_ID,
HDR.MC_ID,
HDR.VERSION_NUMBER,
HDR.CONFIG_STATUS_CODE
FROM AHL_MC_RELATIONSHIPS REL,
(
SELECT MCB.MC_HEADER_ID,
MCB.MC_ID,
MCB.VERSION_NUMBER,
DECODE (MCB.CONFIG_STATUS_CODE,
'CLOSED', MCB.CONFIG_STATUS_CODE,
DECODE (SIGN(TRUNC(NVL(MCR.ACTIVE_END_DATE, SYSDATE+1)) - TRUNC(SYSDATE)),
1, MCB.CONFIG_STATUS_CODE, 'EXPIRED')) CONFIG_STATUS_CODE
FROM AHL_MC_HEADERS_B MCB, AHL_MC_RELATIONSHIPS MCR
WHERE MCB.MC_HEADER_ID = MCR.MC_HEADER_ID
AND MCR.PARENT_RELATIONSHIP_ID IS NULL
) HDR,
FND_LOOKUP_VALUES FPRC,
FND_LOOKUP_VALUES FPNC,
FND_LOOKUP_VALUES FATA
WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_parent_rel_id,0)
AND REL.MC_HEADER_ID = p_mc_header_id
AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
AND TRUNC(NVL(REL.ACTIVE_END_DATE, SYSDATE + 1)) > TRUNC(SYSDATE)
AND FPRC.LOOKUP_CODE (+) = REL.POSITION_REF_CODE
AND FPRC.LOOKUP_TYPE (+) = 'AHL_POSITION_REFERENCE'
AND FPRC.LANGUAGE (+) = USERENV('LANG')
AND FPRC.VIEW_APPLICATION_ID (+) = 0
AND FPNC.LOOKUP_CODE (+) = REL.POSITION_NECESSITY_CODE
AND FPNC.LOOKUP_TYPE (+) = 'AHL_POSITION_NECESSITY'
AND FPNC.LANGUAGE (+) = USERENV('LANG')
AND FPNC.VIEW_APPLICATION_ID (+) = 0
AND FATA.LOOKUP_CODE (+) = REL.ATA_CODE
AND FATA.LOOKUP_TYPE (+) = 'AHL_ATA_CODE'
AND FATA.LANGUAGE (+) = USERENV('LANG')
AND FATA.VIEW_APPLICATION_ID (+) = 0
ORDER BY DISPLAY_ORDER;
SELECT REL.RELATIONSHIP_ID,
REL.OBJECT_VERSION_NUMBER,
REL.POSITION_KEY,
REL.PARENT_RELATIONSHIP_ID,
REL.ITEM_GROUP_ID,
REL.POSITION_REF_CODE,
FPRC.MEANING POSITION_REF_MEANING,
--R12
--priyan MEL-CDL
REL.ATA_CODE,
FATA.MEANING ATA_MEANING,
REL.POSITION_NECESSITY_CODE,
FPNC.MEANING POSITION_NECESSITY_MEANING,
REL.UOM_CODE,
REL.QUANTITY,
REL.DISPLAY_ORDER,
REL.ACTIVE_START_DATE,
REL.ACTIVE_END_DATE,
REL.MC_HEADER_ID,
HDR.MC_ID,
HDR.VERSION_NUMBER,
HDR.CONFIG_STATUS_CODE
FROM AHL_MC_RELATIONSHIPS REL,
AHL_MC_HEADERS_V HDR,
FND_LOOKUP_VALUES_VL FPRC,
FND_LOOKUP_VALUES_VL FPNC,
FND_LOOKUP_VALUES_VL FATA
WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_relationship_id,0)
AND REL.MC_HEADER_ID = p_mc_header_id
AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
AND TRUNC(NVL(REL.ACTIVE_END_DATE, SYSDATE + 1)) > TRUNC(SYSDATE)
AND FPRC.LOOKUP_CODE (+) = REL.POSITION_REF_CODE
AND FPRC.LOOKUP_TYPE (+) = 'AHL_POSITION_REFERENCE'
AND FPNC.LOOKUP_CODE (+) = REL.POSITION_NECESSITY_CODE
AND FPNC.LOOKUP_TYPE (+) = 'AHL_POSITION_NECESSITY'
AND FATA.LOOKUP_CODE (+) = REL.ATA_CODE
AND FATA.LOOKUP_TYPE (+) = 'AHL_ATA_CODE'
ORDER BY DISPLAY_ORDER;
SELECT REL.RELATIONSHIP_ID,
REL.OBJECT_VERSION_NUMBER,
REL.POSITION_KEY,
REL.PARENT_RELATIONSHIP_ID,
REL.ITEM_GROUP_ID,
REL.POSITION_REF_CODE,
FPRC.MEANING POSITION_REF_MEANING,
--R12
--priyan MEL-CDL
REL.ATA_CODE,
FATA.MEANING ATA_MEANING,
REL.POSITION_NECESSITY_CODE,
FPNC.MEANING POSITION_NECESSITY_MEANING,
REL.UOM_CODE,
REL.QUANTITY,
REL.DISPLAY_ORDER,
REL.ACTIVE_START_DATE,
REL.ACTIVE_END_DATE,
REL.MC_HEADER_ID,
HDR.MC_ID,
HDR.VERSION_NUMBER,
HDR.CONFIG_STATUS_CODE
FROM AHL_MC_RELATIONSHIPS REL,
AHL_MC_HEADERS_V HDR,
FND_LOOKUP_VALUES_VL FPRC,
FND_LOOKUP_VALUES_VL FPNC,
FND_LOOKUP_VALUES_VL FATA
WHERE REL.PARENT_RELATIONSHIP_ID IS NULL
AND REL.MC_HEADER_ID = p_mc_header_id
AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
AND FPRC.LOOKUP_CODE (+) = REL.POSITION_REF_CODE
AND FPRC.LOOKUP_TYPE (+) = 'AHL_POSITION_REFERENCE'
AND FPNC.LOOKUP_CODE (+) = REL.POSITION_NECESSITY_CODE
AND FPNC.LOOKUP_TYPE (+) = 'AHL_POSITION_NECESSITY'
AND FATA.LOOKUP_CODE (+) = REL.ATA_CODE
AND FATA.LOOKUP_TYPE (+) = 'AHL_ATA_CODE'
ORDER BY DISPLAY_ORDER;
SELECT REL.RELATIONSHIP_ID,
REL.OBJECT_VERSION_NUMBER,
REL.POSITION_KEY,
REL.PARENT_RELATIONSHIP_ID,
REL.ITEM_GROUP_ID,
REL.POSITION_REF_CODE,
FPRC.MEANING POSITION_REF_MEANING,
--R12
--priyan MEL-CDL
REL.ATA_CODE,
FATA.MEANING ATA_MEANING,
REL.POSITION_NECESSITY_CODE,
FPNC.MEANING POSITION_NECESSITY_MEANING,
REL.UOM_CODE,
REL.QUANTITY,
REL.DISPLAY_ORDER,
REL.ACTIVE_START_DATE,
REL.ACTIVE_END_DATE,
REL.MC_HEADER_ID,
HDR.MC_ID,
HDR.VERSION_NUMBER,
HDR.CONFIG_STATUS_CODE
FROM AHL_MC_RELATIONSHIPS REL,
AHL_MC_HEADERS_V HDR,
FND_LOOKUP_VALUES_VL FPRC,
FND_LOOKUP_VALUES_VL FPNC,
FND_LOOKUP_VALUES_VL FATA
WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_parent_rel_id,0)
AND REL.MC_HEADER_ID = p_mc_header_id
AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
AND TRUNC(NVL(REL.ACTIVE_END_DATE, SYSDATE + 1)) > TRUNC(SYSDATE)
AND FPRC.LOOKUP_CODE (+) = REL.POSITION_REF_CODE
AND FPRC.LOOKUP_TYPE (+) = 'AHL_POSITION_REFERENCE'
AND FPNC.LOOKUP_CODE (+) = REL.POSITION_NECESSITY_CODE
AND FPNC.LOOKUP_TYPE (+) = 'AHL_POSITION_NECESSITY'
AND FATA.LOOKUP_CODE (+) = REL.ATA_CODE
AND FATA.LOOKUP_TYPE (+) = 'AHL_ATA_CODE'
ORDER BY DISPLAY_ORDER;