View: PO_GA_ORG_ASSIGN_MERGE_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.PO_GA_ORG_ASSIGN_MERGE_V

View Text

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
FROM PO_GA_ORG_ASSIGN_DRAFT PGOAD
, PO_DRAFTS DFT
WHERE PGOAD.DRAFT_ID = DFT.DRAFT_ID
AND PGOAD.DELETE_FLAG IS NULL
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
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')

Columns