VIEW: APPS.PO_GA_ORG_ASSIGN_MERGE_V

Source

View Text - Preformatted

SELECT dft.owner_user_id, dft.owner_role, dft.status, dft.draft_id, pgoad.change_accepted_flag, pgoad.delete_flag, pgoad.po_header_id, pgoad.organization_id, pgoad.enabled_flag, pgoad.vendor_site_id, pgoad.last_update_date, pgoad.last_updated_by, pgoad.creation_date, pgoad.created_by, pgoad.last_update_login, pgoad.purchasing_org_id, pgoad.org_assignment_id, pgoad.change_status FROM po_ga_org_assign_draft pgoad, po_drafts dft WHERE pgoad.draft_id = dft.draft_id AND Nvl(pgoad.delete_flag,'N') = 'N' UNION ALL SELECT To_number(NULL), NULL, NULL, To_number(-1), NULL, NULL, pgoa.po_header_id, pgoa.organization_id, pgoa.enabled_flag, pgoa.vendor_site_id, pgoa.last_update_date, pgoa.last_updated_by, pgoa.creation_date, pgoa.created_by, pgoa.last_update_login, pgoa.purchasing_org_id, pgoa.org_assignment_id, NULL FROM po_ga_org_assignments pgoa UNION ALL SELECT To_number(NULL), NULL, NULL, dft.draft_id, NULL, NULL, pgoa.po_header_id, pgoa.organization_id, pgoa.enabled_flag, pgoa.vendor_site_id, pgoa.last_update_date, pgoa.last_updated_by, pgoa.creation_date, pgoa.created_by, pgoa.last_update_login, pgoa.purchasing_org_id, pgoa.org_assignment_id, NULL FROM po_ga_org_assignments pgoa, po_drafts dft WHERE pgoa.po_header_id = dft.document_id AND NOT EXISTS (SELECT 'Draft Exists For This Org Assignment' FROM po_ga_org_assign_draft pgoad WHERE pgoa.po_header_id = pgoad.po_header_id AND pgoa.organization_id = pgoad.organization_id AND pgoad.draft_id = dft.draft_id AND Nvl(pgoad.delete_flag,'N') = 'N')

View Text - HTML Formatted

SELECT DFT.OWNER_USER_ID
, DFT.OWNER_ROLE
, DFT.STATUS
, DFT.DRAFT_ID
, PGOAD.CHANGE_ACCEPTED_FLAG
, PGOAD.DELETE_FLAG
, PGOAD.PO_HEADER_ID
, PGOAD.ORGANIZATION_ID
, PGOAD.ENABLED_FLAG
, PGOAD.VENDOR_SITE_ID
, PGOAD.LAST_UPDATE_DATE
, PGOAD.LAST_UPDATED_BY
, PGOAD.CREATION_DATE
, PGOAD.CREATED_BY
, PGOAD.LAST_UPDATE_LOGIN
, PGOAD.PURCHASING_ORG_ID
, PGOAD.ORG_ASSIGNMENT_ID
, PGOAD.CHANGE_STATUS
FROM PO_GA_ORG_ASSIGN_DRAFT PGOAD
, PO_DRAFTS DFT
WHERE PGOAD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PGOAD.DELETE_FLAG
, 'N') = 'N' UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(-1)
, NULL
, NULL
, PGOA.PO_HEADER_ID
, PGOA.ORGANIZATION_ID
, PGOA.ENABLED_FLAG
, PGOA.VENDOR_SITE_ID
, PGOA.LAST_UPDATE_DATE
, PGOA.LAST_UPDATED_BY
, PGOA.CREATION_DATE
, PGOA.CREATED_BY
, PGOA.LAST_UPDATE_LOGIN
, PGOA.PURCHASING_ORG_ID
, PGOA.ORG_ASSIGNMENT_ID
, NULL
FROM PO_GA_ORG_ASSIGNMENTS PGOA UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, DFT.DRAFT_ID
, NULL
, NULL
, PGOA.PO_HEADER_ID
, PGOA.ORGANIZATION_ID
, PGOA.ENABLED_FLAG
, PGOA.VENDOR_SITE_ID
, PGOA.LAST_UPDATE_DATE
, PGOA.LAST_UPDATED_BY
, PGOA.CREATION_DATE
, PGOA.CREATED_BY
, PGOA.LAST_UPDATE_LOGIN
, PGOA.PURCHASING_ORG_ID
, PGOA.ORG_ASSIGNMENT_ID
, NULL
FROM PO_GA_ORG_ASSIGNMENTS PGOA
, PO_DRAFTS DFT
WHERE PGOA.PO_HEADER_ID = DFT.DOCUMENT_ID
AND NOT EXISTS (SELECT 'DRAFT EXISTS FOR THIS ORG ASSIGNMENT'
FROM PO_GA_ORG_ASSIGN_DRAFT PGOAD
WHERE PGOA.PO_HEADER_ID = PGOAD.PO_HEADER_ID
AND PGOA.ORGANIZATION_ID = PGOAD.ORGANIZATION_ID
AND PGOAD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PGOAD.DELETE_FLAG
, 'N') = 'N')