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.ENG_WORKFLOW_UTIL dependencies on HZ_PARTIES

Line 638: FROM HZ_PARTIES

634: BEGIN
635:
636: SELECT party_type
637: INTO l_party_type
638: FROM HZ_PARTIES
639: WHERE party_id = p_party_id ;
640:
641: RETURN l_party_type ;
642:

Line 849: -- , HZ_PARTIES grp

845: -- IS
846: -- SELECT member.user_name user_role
847: -- FROM EGO_PEOPLE_V member
848: -- , HZ_RELATIONSHIPS member_group
849: -- , HZ_PARTIES grp
850: -- WHERE member_group.object_id = grp.party_id
851: -- AND member_group.subject_id = member.person_id
852: -- AND member_group.subject_type = 'PERSON'
853: -- AND member_group.object_type = 'GROUP'

Line 1966: HZ_PARTIES company,

1962: , company.party_name comp_name
1963: INTO x_party_name
1964: , x_party_company
1965: FROM HZ_RELATIONSHIPS emp_cmpy,
1966: HZ_PARTIES company,
1967: HZ_RELATIONSHIPS owner_group_rel,
1968: HZ_PARTIES owner ,
1969: HZ_PARTIES grp
1970: WHERE emp_cmpy.subject_type (+)= 'PERSON'

Line 1968: HZ_PARTIES owner ,

1964: , x_party_company
1965: FROM HZ_RELATIONSHIPS emp_cmpy,
1966: HZ_PARTIES company,
1967: HZ_RELATIONSHIPS owner_group_rel,
1968: HZ_PARTIES owner ,
1969: HZ_PARTIES grp
1970: WHERE emp_cmpy.subject_type (+)= 'PERSON'
1971: AND emp_cmpy.subject_table_name (+)= 'HZ_PARTIES'
1972: AND emp_cmpy.object_type (+)= 'ORGANIZATION'

Line 1969: HZ_PARTIES grp

1965: FROM HZ_RELATIONSHIPS emp_cmpy,
1966: HZ_PARTIES company,
1967: HZ_RELATIONSHIPS owner_group_rel,
1968: HZ_PARTIES owner ,
1969: HZ_PARTIES grp
1970: WHERE emp_cmpy.subject_type (+)= 'PERSON'
1971: AND emp_cmpy.subject_table_name (+)= 'HZ_PARTIES'
1972: AND emp_cmpy.object_type (+)= 'ORGANIZATION'
1973: AND emp_cmpy.relationship_code (+)= 'EMPLOYEE_OF'

Line 1971: AND emp_cmpy.subject_table_name (+)= 'HZ_PARTIES'

1967: HZ_RELATIONSHIPS owner_group_rel,
1968: HZ_PARTIES owner ,
1969: HZ_PARTIES grp
1970: WHERE emp_cmpy.subject_type (+)= 'PERSON'
1971: AND emp_cmpy.subject_table_name (+)= 'HZ_PARTIES'
1972: AND emp_cmpy.object_type (+)= 'ORGANIZATION'
1973: AND emp_cmpy.relationship_code (+)= 'EMPLOYEE_OF'
1974: AND emp_cmpy.object_table_name(+)= 'HZ_PARTIES'
1975: AND emp_cmpy.status (+)= 'A'

Line 1974: AND emp_cmpy.object_table_name(+)= 'HZ_PARTIES'

1970: WHERE emp_cmpy.subject_type (+)= 'PERSON'
1971: AND emp_cmpy.subject_table_name (+)= 'HZ_PARTIES'
1972: AND emp_cmpy.object_type (+)= 'ORGANIZATION'
1973: AND emp_cmpy.relationship_code (+)= 'EMPLOYEE_OF'
1974: AND emp_cmpy.object_table_name(+)= 'HZ_PARTIES'
1975: AND emp_cmpy.status (+)= 'A'
1976: AND emp_cmpy.start_date (+)<= SYSDATE
1977: AND ( emp_cmpy.end_date IS NULL OR emp_cmpy.end_date >= SYSDATE)
1978: AND company.party_id (+)= emp_cmpy.object_id

Line 1984: AND owner_group_rel.subject_table_name = 'HZ_PARTIES'

1980: AND emp_cmpy.subject_id (+)= owner.party_id
1981: -- AND owner.status='A'
1982: AND owner.party_id = owner_group_rel.subject_id
1983: AND owner_group_rel.subject_type = 'PERSON'
1984: AND owner_group_rel.subject_table_name = 'HZ_PARTIES'
1985: AND owner_group_rel.object_type = 'GROUP'
1986: AND owner_group_rel.object_table_name = 'HZ_PARTIES'
1987: AND owner_group_rel.relationship_code = 'OWNER_OF'
1988: AND owner_group_rel.status = 'A'

Line 1986: AND owner_group_rel.object_table_name = 'HZ_PARTIES'

1982: AND owner.party_id = owner_group_rel.subject_id
1983: AND owner_group_rel.subject_type = 'PERSON'
1984: AND owner_group_rel.subject_table_name = 'HZ_PARTIES'
1985: AND owner_group_rel.object_type = 'GROUP'
1986: AND owner_group_rel.object_table_name = 'HZ_PARTIES'
1987: AND owner_group_rel.relationship_code = 'OWNER_OF'
1988: AND owner_group_rel.status = 'A'
1989: AND owner_group_rel.start_date <= SYSDATE
1990: AND ( owner_group_rel.end_date IS NULL OR owner_group_rel.end_date >= SYSDATE)

Line 2021: FROM hz_parties employee

2017: SELECT employee.party_name party_name
2018: , company.party_name comp_name
2019: INTO x_party_name
2020: , x_party_company
2021: FROM hz_parties employee
2022: , hz_relationships emp_cmpy
2023: , hz_parties company
2024: WHERE emp_cmpy.subject_type (+)= 'PERSON'
2025: AND emp_cmpy.subject_table_name (+)= 'HZ_PARTIES'

Line 2023: , hz_parties company

2019: INTO x_party_name
2020: , x_party_company
2021: FROM hz_parties employee
2022: , hz_relationships emp_cmpy
2023: , hz_parties company
2024: WHERE emp_cmpy.subject_type (+)= 'PERSON'
2025: AND emp_cmpy.subject_table_name (+)= 'HZ_PARTIES'
2026: AND emp_cmpy.object_type (+)= 'ORGANIZATION'
2027: AND emp_cmpy.relationship_code (+)= 'EMPLOYEE_OF'

Line 2025: AND emp_cmpy.subject_table_name (+)= 'HZ_PARTIES'

2021: FROM hz_parties employee
2022: , hz_relationships emp_cmpy
2023: , hz_parties company
2024: WHERE emp_cmpy.subject_type (+)= 'PERSON'
2025: AND emp_cmpy.subject_table_name (+)= 'HZ_PARTIES'
2026: AND emp_cmpy.object_type (+)= 'ORGANIZATION'
2027: AND emp_cmpy.relationship_code (+)= 'EMPLOYEE_OF'
2028: AND emp_cmpy.object_table_name (+)= 'HZ_PARTIES'
2029: AND emp_cmpy.status (+)= 'A'

Line 2028: AND emp_cmpy.object_table_name (+)= 'HZ_PARTIES'

2024: WHERE emp_cmpy.subject_type (+)= 'PERSON'
2025: AND emp_cmpy.subject_table_name (+)= 'HZ_PARTIES'
2026: AND emp_cmpy.object_type (+)= 'ORGANIZATION'
2027: AND emp_cmpy.relationship_code (+)= 'EMPLOYEE_OF'
2028: AND emp_cmpy.object_table_name (+)= 'HZ_PARTIES'
2029: AND emp_cmpy.status (+)= 'A'
2030: AND emp_cmpy.start_date (+) <= SYSDATE
2031: AND (emp_cmpy.end_date IS NULL OR emp_cmpy.end_date >= SYSDATE)
2032: -- AND employee.status = 'A'

Line 14008: , p_party_ids => l_doc_rev_person_id_tbl -- Person's HZ_PARTIES.PARTY_ID Array

14004: , p_document_id => l_document_id -- Dom Document Id
14005: , p_document_revision_id => l_document_revision_id -- Dom Document Revision Id
14006: , p_change_id => l_change_id -- Change Id
14007: , p_change_line_id => l_change_line_id -- Change Line Id
14008: , p_party_ids => l_doc_rev_person_id_tbl -- Person's HZ_PARTIES.PARTY_ID Array
14009: , p_role_id => l_document_role_id -- Role Id to be granted
14010: , p_api_caller => p_api_caller -- Optionnal for future use
14011: ) ;
14012:

Line 14076: , p_party_ids => l_ocs_person_id_tbl -- Person's HZ_PARTIES.PARTY_ID Array

14072: , p_pk2value => NULL
14073: , p_pk3value => NULL
14074: , p_pk4value => NULL
14075: , p_pk5value => NULL
14076: , p_party_ids => l_ocs_person_id_tbl -- Person's HZ_PARTIES.PARTY_ID Array
14077: , p_ocs_role => l_ocs_role -- OCS Role to be granted
14078: , p_source_media_id_tbl => l_source_mdedia_ids
14079: , p_attachment_id_tbl => l_attachment_ids
14080: , p_repository_id_tbl => l_repository_ids

Line 14954: , p_party_ids => l_doc_rev_person_id_tbl -- Person's HZ_PARTIES.PARTY_ID Array

14950: , p_document_id => l_document_id -- Dom Document Id
14951: , p_document_revision_id => l_document_revision_id -- Dom Document Revision Id
14952: , p_change_id => l_change_id -- Change Id
14953: , p_change_line_id => l_change_line_id -- Change Line Id
14954: , p_party_ids => l_doc_rev_person_id_tbl -- Person's HZ_PARTIES.PARTY_ID Array
14955: , p_role_id => l_document_role_id -- Role Id to be granted
14956: , p_api_caller => p_api_caller -- Optionnal for future use
14957: ) ;
14958:

Line 15009: , p_party_ids => l_ocs_person_id_tbl -- Person's HZ_PARTIES.PARTY_ID Array

15005: , p_pk2value => NULL
15006: , p_pk3value => NULL
15007: , p_pk4value => NULL
15008: , p_pk5value => NULL
15009: , p_party_ids => l_ocs_person_id_tbl -- Person's HZ_PARTIES.PARTY_ID Array
15010: , p_ocs_role => l_ocs_role -- OCS Role to be revoked
15011: , p_api_caller => p_api_caller -- Optionnal for future use
15012: ) ;
15013: