eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_CREATE_LINES_PKG dependencies on AMW_LATEST_REV_ORG_V

Line 714: from amw_org_hierarchy_denorm d, amw_latest_rev_org_v a

710: ,a.DISPLAY_NAME
711: ,a.REVISION_NUMBER
712: ,a.approval_status
713: ,a.description
714: from amw_org_hierarchy_denorm d, amw_latest_rev_org_v a
715: where d.process_id = p_pk2 --processId
716: and d.organization_id = p_pk1 --organizationId
717: and up_down_ind = 'D'
718: and hierarchy_type = 'L'

Line 736: FROM amw_latest_rev_org_v ALR

732: ,ALR.DISPLAY_NAME
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

Line 748: FROM amw_latest_rev_org_v ALR

744: ,ALR.DISPLAY_NAME
745: ,ALR.DESCRIPTION
746: ,ALR.PROCESS_CODE
747: --,alr.revision_number
748: FROM amw_latest_rev_org_v ALR
749: ,AMW_CURR_APP_HIERARCHY_ORG_V APHD
750: WHERE APHD.CHILD_process_ID=ALR.PROCESS_ID
751: and alr.ORGANIZATION_ID=p_pk1 --organizationId
752: and aphd.CHILD_ORGANIZATION_ID=p_pk1 --organizationId

Line 763: FROM amw_latest_rev_org_v ALR

759: ,ALR.DISPLAY_NAME
760: ,ALR.DESCRIPTION
761: ,ALR.PROCESS_CODE
762: --,alr.revision_number
763: FROM amw_latest_rev_org_v ALR
764: ,AMW_CURR_APP_HIERARCHY_ORG_V APHD
765: WHERE APHD.CHILD_process_ID=ALR.PROCESS_ID
766: and alr.ORGANIZATION_ID=p_pk1 --organizationId
767: and aphd.CHILD_ORGANIZATION_ID=p_pk1 --organizationId

Line 775: FROM amw_latest_rev_org_v ALR

771: ,ALR.DISPLAY_NAME
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

Line 1010: from amw_latest_rev_org_v

1006: ---there may be an immediate child Process, which is also in Draft status
1007: ---in this case, the AddProcess Cursor's 'minus' clause causes problems in
1008: ---revisionNumber data, and incorrect resultSet is obtained.
1009: select revision_number into l_revision_number
1010: from amw_latest_rev_org_v
1011: where organization_id=p_pk1
1012: and process_id=add_proc_rec.process_id;
1013:
1014: process_lines(