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 FROM po_ga_org_assign_draft PGOAD, po_drafts DFT WHERE PGOAD.draft_id = DFT.draft_id AND NVL(PGOAD.delete_flag, 'N') = 'N' AND DFT.owner_role = PO_GLOBAL.role AND DFT.status <> 'COMPLETED' UNION ALL SELECT TO_NUMBER(NULL) ,NULL ,NULL ,TO_NUMBER(NULL) ,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 FROM po_ga_org_assignments PGOA WHERE NOT EXISTS ( SELECT 1 FROM po_ga_org_assign_draft PGOAD1, po_drafts DFT1 WHERE PGOA.po_header_id = PGOAD1.po_header_id AND PGOA.organization_id = PGOAD1.organization_id AND PGOAD1.draft_id = DFT1.draft_id AND DFT1.owner_role = PO_GLOBAL.role AND DFT1.status <> 'COMPLETED')

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
FROM PO_GA_ORG_ASSIGN_DRAFT PGOAD
, PO_DRAFTS DFT
WHERE PGOAD.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PGOAD.DELETE_FLAG
, 'N') = 'N'
AND DFT.OWNER_ROLE = PO_GLOBAL.ROLE
AND DFT.STATUS <> 'COMPLETED' UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, 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
FROM PO_GA_ORG_ASSIGNMENTS PGOA
WHERE NOT EXISTS ( SELECT 1
FROM PO_GA_ORG_ASSIGN_DRAFT PGOAD1
, PO_DRAFTS DFT1
WHERE PGOA.PO_HEADER_ID = PGOAD1.PO_HEADER_ID
AND PGOA.ORGANIZATION_ID = PGOAD1.ORGANIZATION_ID
AND PGOAD1.DRAFT_ID = DFT1.DRAFT_ID
AND DFT1.OWNER_ROLE = PO_GLOBAL.ROLE
AND DFT1.STATUS <> 'COMPLETED')