VIEW: APPS.IEC_O_LISTS_TO_COPY_V

Source

View Text - Preformatted

SELECT DISTINCT C.FROM_LIST_HEADER_ID , C.FROM_SCHEDULE_ID , D.TO_LIST_HEADER_ID , D.TO_SCHEDULE_ID FROM IEC_O_MOVE_RECORDS_STATUS A , (SELECT E.FROM_LIST_HEADER_ID , F.SCHEDULE_ID FROM_SCHEDULE_ID , F.CALL_CENTER_READY_FLAG FROM_CALL_CENTER_READY_FLAG , F.STATUS_CODE FROM_STATUS_CODE , K.VALIDATED_ONCE_FLAG FROM_VALIDATED_ONCE_FLAG FROM IEC_O_MOVE_RECORDS_STATUS E , IEC_G_AO_LISTS_V F, IEC_O_VALIDATION_STATUS K WHERE E.FROM_LIST_HEADER_ID = F.LIST_HEADER_ID AND E.FROM_LIST_HEADER_ID = K.LIST_HEADER_ID) C , (SELECT G.TO_LIST_HEADER_ID , H.SCHEDULE_ID TO_SCHEDULE_ID , H.CALL_CENTER_READY_FLAG TO_CALL_CENTER_READY_FLAG , H.STATUS_CODE TO_STATUS_CODE , L.VALIDATED_ONCE_FLAG TO_VALIDATED_ONCE_FLAG FROM IEC_O_MOVE_RECORDS_STATUS G , IEC_G_AO_LISTS_V H , IEC_O_VALIDATION_STATUS L WHERE G.TO_LIST_HEADER_ID = H.LIST_HEADER_ID AND G.TO_LIST_HEADER_ID = L.LIST_HEADER_ID) D WHERE A.FROM_LIST_HEADER_ID = C.FROM_LIST_HEADER_ID AND A.TO_LIST_HEADER_ID = D.TO_LIST_HEADER_ID AND A.MOVE_RECORDS_STATUS_CODE IN ('MOVING', 'PENDING_MOVE') AND (A.SCHEDULED_EXECUTION_TIME IS NULL OR A.SCHEDULED_EXECUTION_TIME <= SYSDATE) AND C.FROM_VALIDATED_ONCE_FLAG = 'Y' AND C.FROM_STATUS_CODE IN ('ACTIVE', 'INACTIVE', 'VALIDATED') AND C.FROM_CALL_CENTER_READY_FLAG = 'Y' AND D.TO_VALIDATED_ONCE_FLAG = 'Y' AND D.TO_STATUS_CODE IN ('ACTIVE', 'INACTIVE', 'VALIDATED') AND D.TO_CALL_CENTER_READY_FLAG = 'Y' AND (A.API_INITIATED_FLAG IS NULL OR A.API_INITIATED_FLAG <> 'Y')

View Text - HTML Formatted

SELECT DISTINCT C.FROM_LIST_HEADER_ID
, C.FROM_SCHEDULE_ID
, D.TO_LIST_HEADER_ID
, D.TO_SCHEDULE_ID
FROM IEC_O_MOVE_RECORDS_STATUS A
, (SELECT E.FROM_LIST_HEADER_ID
, F.SCHEDULE_ID FROM_SCHEDULE_ID
, F.CALL_CENTER_READY_FLAG FROM_CALL_CENTER_READY_FLAG
, F.STATUS_CODE FROM_STATUS_CODE
, K.VALIDATED_ONCE_FLAG FROM_VALIDATED_ONCE_FLAG
FROM IEC_O_MOVE_RECORDS_STATUS E
, IEC_G_AO_LISTS_V F
, IEC_O_VALIDATION_STATUS K
WHERE E.FROM_LIST_HEADER_ID = F.LIST_HEADER_ID
AND E.FROM_LIST_HEADER_ID = K.LIST_HEADER_ID) C
, (SELECT G.TO_LIST_HEADER_ID
, H.SCHEDULE_ID TO_SCHEDULE_ID
, H.CALL_CENTER_READY_FLAG TO_CALL_CENTER_READY_FLAG
, H.STATUS_CODE TO_STATUS_CODE
, L.VALIDATED_ONCE_FLAG TO_VALIDATED_ONCE_FLAG
FROM IEC_O_MOVE_RECORDS_STATUS G
, IEC_G_AO_LISTS_V H
, IEC_O_VALIDATION_STATUS L
WHERE G.TO_LIST_HEADER_ID = H.LIST_HEADER_ID
AND G.TO_LIST_HEADER_ID = L.LIST_HEADER_ID) D
WHERE A.FROM_LIST_HEADER_ID = C.FROM_LIST_HEADER_ID
AND A.TO_LIST_HEADER_ID = D.TO_LIST_HEADER_ID
AND A.MOVE_RECORDS_STATUS_CODE IN ('MOVING'
, 'PENDING_MOVE')
AND (A.SCHEDULED_EXECUTION_TIME IS NULL OR A.SCHEDULED_EXECUTION_TIME <= SYSDATE)
AND C.FROM_VALIDATED_ONCE_FLAG = 'Y'
AND C.FROM_STATUS_CODE IN ('ACTIVE'
, 'INACTIVE'
, 'VALIDATED')
AND C.FROM_CALL_CENTER_READY_FLAG = 'Y'
AND D.TO_VALIDATED_ONCE_FLAG = 'Y'
AND D.TO_STATUS_CODE IN ('ACTIVE'
, 'INACTIVE'
, 'VALIDATED')
AND D.TO_CALL_CENTER_READY_FLAG = 'Y'
AND (A.API_INITIATED_FLAG IS NULL OR A.API_INITIATED_FLAG <> 'Y')