VIEW: APPS.PO_NOTIFICATION_CTRL_MERGE_V

Source

View Text - Preformatted

SELECT dft.owner_user_id, dft.owner_role, dft.status, dft.draft_id, pncd.change_accepted_flag, pncd.delete_flag, pncd.notification_id, pncd.po_header_id, pncd.start_date_active, pncd.end_date_active, pncd.notification_amount, pncd.notification_condition_code, pncd.notification_qty_percentage, pncd.last_update_date, pncd.last_update_login, pncd.last_updated_by, pncd.program_id, pncd.created_by, pncd.creation_date, pncd.attribute_category, pncd.attribute1, pncd.attribute2, pncd.attribute3, pncd.attribute4, pncd.attribute5, pncd.attribute6, pncd.attribute7, pncd.attribute8, pncd.attribute9, pncd.attribute10, pncd.attribute11, pncd.attribute12, pncd.attribute13, pncd.attribute14, pncd.attribute15, pncd.program_application_id, pncd.program_update_date, pncd.request_id, pncd.change_status FROM po_notification_ctrl_draft pncd, po_drafts dft WHERE pncd.draft_id = dft.draft_id AND Nvl(pncd.delete_flag,'N') = 'N' UNION ALL SELECT To_number(NULL), NULL, NULL, To_number(-1), NULL, NULL, pnc.notification_id, pnc.po_header_id, pnc.start_date_active, pnc.end_date_active, pnc.notification_amount, pnc.notification_condition_code, pnc.notification_qty_percentage, pnc.last_update_date, pnc.last_update_login, pnc.last_updated_by, pnc.program_id, pnc.created_by, pnc.creation_date, pnc.attribute_category, pnc.attribute1, pnc.attribute2, pnc.attribute3, pnc.attribute4, pnc.attribute5, pnc.attribute6, pnc.attribute7, pnc.attribute8, pnc.attribute9, pnc.attribute10, pnc.attribute11, pnc.attribute12, pnc.attribute13, pnc.attribute14, pnc.attribute15, pnc.program_application_id, pnc.program_update_date, pnc.request_id, NULL FROM po_notification_controls pnc Union All SELECT To_number(NULL), NULL, NULL, dft.Draft_Id, NULL, NULL, pnc.notification_id, pnc.po_header_id, pnc.start_date_active, pnc.end_date_active, pnc.notification_amount, pnc.notification_condition_code, pnc.notification_qty_percentage, pnc.last_update_date, pnc.last_update_login, pnc.last_updated_by, pnc.program_id, pnc.created_by, pnc.creation_date, pnc.attribute_category, pnc.attribute1, pnc.attribute2, pnc.attribute3, pnc.attribute4, pnc.attribute5, pnc.attribute6, pnc.attribute7, pnc.attribute8, pnc.attribute9, pnc.attribute10, pnc.attribute11, pnc.attribute12, pnc.attribute13, pnc.attribute14, pnc.attribute15, pnc.program_application_id, pnc.program_update_date, pnc.request_id, NULL FROM po_notification_controls pnc, po_drafts dft Where pnc.po_header_id = dft.Document_id and NOT EXISTS (SELECT 1 FROM po_notification_ctrl_draft pncd WHERE pnc.notification_id = pncd.notification_id AND pncd.draft_id = dft.draft_id AND Nvl(pncd.delete_flag,'N') = 'N')

View Text - HTML Formatted

SELECT DFT.OWNER_USER_ID
, DFT.OWNER_ROLE
, DFT.STATUS
, DFT.DRAFT_ID
, PNCD.CHANGE_ACCEPTED_FLAG
, PNCD.DELETE_FLAG
, PNCD.NOTIFICATION_ID
, PNCD.PO_HEADER_ID
, PNCD.START_DATE_ACTIVE
, PNCD.END_DATE_ACTIVE
, PNCD.NOTIFICATION_AMOUNT
, PNCD.NOTIFICATION_CONDITION_CODE
, PNCD.NOTIFICATION_QTY_PERCENTAGE
, PNCD.LAST_UPDATE_DATE
, PNCD.LAST_UPDATE_LOGIN
, PNCD.LAST_UPDATED_BY
, PNCD.PROGRAM_ID
, PNCD.CREATED_BY
, PNCD.CREATION_DATE
, PNCD.ATTRIBUTE_CATEGORY
, PNCD.ATTRIBUTE1
, PNCD.ATTRIBUTE2
, PNCD.ATTRIBUTE3
, PNCD.ATTRIBUTE4
, PNCD.ATTRIBUTE5
, PNCD.ATTRIBUTE6
, PNCD.ATTRIBUTE7
, PNCD.ATTRIBUTE8
, PNCD.ATTRIBUTE9
, PNCD.ATTRIBUTE10
, PNCD.ATTRIBUTE11
, PNCD.ATTRIBUTE12
, PNCD.ATTRIBUTE13
, PNCD.ATTRIBUTE14
, PNCD.ATTRIBUTE15
, PNCD.PROGRAM_APPLICATION_ID
, PNCD.PROGRAM_UPDATE_DATE
, PNCD.REQUEST_ID
, PNCD.CHANGE_STATUS
FROM PO_NOTIFICATION_CTRL_DRAFT PNCD
, PO_DRAFTS DFT
WHERE PNCD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PNCD.DELETE_FLAG
, 'N') = 'N' UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(-1)
, NULL
, NULL
, PNC.NOTIFICATION_ID
, PNC.PO_HEADER_ID
, PNC.START_DATE_ACTIVE
, PNC.END_DATE_ACTIVE
, PNC.NOTIFICATION_AMOUNT
, PNC.NOTIFICATION_CONDITION_CODE
, PNC.NOTIFICATION_QTY_PERCENTAGE
, PNC.LAST_UPDATE_DATE
, PNC.LAST_UPDATE_LOGIN
, PNC.LAST_UPDATED_BY
, PNC.PROGRAM_ID
, PNC.CREATED_BY
, PNC.CREATION_DATE
, PNC.ATTRIBUTE_CATEGORY
, PNC.ATTRIBUTE1
, PNC.ATTRIBUTE2
, PNC.ATTRIBUTE3
, PNC.ATTRIBUTE4
, PNC.ATTRIBUTE5
, PNC.ATTRIBUTE6
, PNC.ATTRIBUTE7
, PNC.ATTRIBUTE8
, PNC.ATTRIBUTE9
, PNC.ATTRIBUTE10
, PNC.ATTRIBUTE11
, PNC.ATTRIBUTE12
, PNC.ATTRIBUTE13
, PNC.ATTRIBUTE14
, PNC.ATTRIBUTE15
, PNC.PROGRAM_APPLICATION_ID
, PNC.PROGRAM_UPDATE_DATE
, PNC.REQUEST_ID
, NULL
FROM PO_NOTIFICATION_CONTROLS PNC UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, DFT.DRAFT_ID
, NULL
, NULL
, PNC.NOTIFICATION_ID
, PNC.PO_HEADER_ID
, PNC.START_DATE_ACTIVE
, PNC.END_DATE_ACTIVE
, PNC.NOTIFICATION_AMOUNT
, PNC.NOTIFICATION_CONDITION_CODE
, PNC.NOTIFICATION_QTY_PERCENTAGE
, PNC.LAST_UPDATE_DATE
, PNC.LAST_UPDATE_LOGIN
, PNC.LAST_UPDATED_BY
, PNC.PROGRAM_ID
, PNC.CREATED_BY
, PNC.CREATION_DATE
, PNC.ATTRIBUTE_CATEGORY
, PNC.ATTRIBUTE1
, PNC.ATTRIBUTE2
, PNC.ATTRIBUTE3
, PNC.ATTRIBUTE4
, PNC.ATTRIBUTE5
, PNC.ATTRIBUTE6
, PNC.ATTRIBUTE7
, PNC.ATTRIBUTE8
, PNC.ATTRIBUTE9
, PNC.ATTRIBUTE10
, PNC.ATTRIBUTE11
, PNC.ATTRIBUTE12
, PNC.ATTRIBUTE13
, PNC.ATTRIBUTE14
, PNC.ATTRIBUTE15
, PNC.PROGRAM_APPLICATION_ID
, PNC.PROGRAM_UPDATE_DATE
, PNC.REQUEST_ID
, NULL
FROM PO_NOTIFICATION_CONTROLS PNC
, PO_DRAFTS DFT
WHERE PNC.PO_HEADER_ID = DFT.DOCUMENT_ID
AND NOT EXISTS (SELECT 1
FROM PO_NOTIFICATION_CTRL_DRAFT PNCD
WHERE PNC.NOTIFICATION_ID = PNCD.NOTIFICATION_ID
AND PNCD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PNCD.DELETE_FLAG
, 'N') = 'N')