DBA Data[Home] [Help]

APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_GA_ORG_ASSIGNMENTS_ARCHIVE

Line 870: po_ga_org_assignments_archive pgoaa

866: -- revision is needed
867: SELECT 'Y'
868: INTO x_different
869: FROM po_ga_org_assignments pgoa,
870: po_ga_org_assignments_archive pgoaa
871: WHERE pgoa.po_header_id = p_doc_id
872: AND pgoa.po_header_id = pgoaa.po_header_id (+)
873: AND pgoa.organization_id = pgoaa.organization_id (+)
874: AND pgoaa.latest_external_flag (+) = 'Y'