DBA Data[Home] [Help]

APPS.AMW_CREATE_LINES_PKG dependencies on AMW_LATEST_HIERARCHY_ORG_V

Line 737: ,AMW_LATEST_HIERARCHY_ORG_V APHD

733: ,ALR.DESCRIPTION
734: ,ALR.PROCESS_CODE
735: --,alr.revision_number
736: FROM amw_latest_rev_org_v ALR
737: ,AMW_LATEST_HIERARCHY_ORG_V APHD
738: WHERE APHD.CHILD_process_ID=ALR.PROCESS_ID
739: and alr.ORGANIZATION_ID=p_pk1 --organizationId
740: and aphd.CHILD_ORGANIZATION_ID=p_pk1 --organizationId
741: AND APHD.parent_PROCESS_ID=p_pk2 --processId

Line 776: ,AMW_LATEST_HIERARCHY_ORG_V APHD

772: ,ALR.DESCRIPTION
773: ,ALR.PROCESS_CODE
774: --,alr.revision_number
775: FROM amw_latest_rev_org_v ALR
776: ,AMW_LATEST_HIERARCHY_ORG_V APHD
777: WHERE APHD.CHILD_process_ID=ALR.PROCESS_ID
778: and alr.ORGANIZATION_ID=p_pk1 --organizationId
779: and aphd.CHILD_ORGANIZATION_ID=p_pk1 --organizationId
780: AND APHD.parent_PROCESS_ID=p_pk2; --processId