[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,
--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;