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.OKS_EXTWAR_UTIL_PUB dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1396: hr_all_organization_units b,

1392: okc_k_party_roles_b party1,
1393: okc_k_party_roles_b party2,
1394: okc_contacts cont,
1395: hz_parties hz,
1396: hr_all_organization_units b,
1397: hr_locations_all c
1398: WHERE hdr.id = p_contract_hdr_id
1399: AND hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )
1400: AND hdr.sts_code = p_status_code

Line 1441: hr_all_organization_units b,

1437: okc_k_party_roles_b party1,
1438: okc_k_party_roles_b party2,
1439: okc_contacts cont,
1440: hz_parties hz,
1441: hr_all_organization_units b,
1442: hr_locations_all c
1443: WHERE hdr.id = p_contract_hdr_id
1444: AND hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )
1445: AND hdr.sts_code = p_status_code

Line 1486: hr_all_organization_units b,

1482: okc_k_party_roles_b party1,
1483: okc_k_party_roles_b party2,
1484: okc_contacts cont,
1485: hz_parties hz,
1486: hr_all_organization_units b,
1487: hr_locations_all c
1488: WHERE hdr.id = p_contract_hdr_id
1489: AND hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )
1490: AND hdr.sts_code = stat.code

Line 1532: hr_all_organization_units b,

1528: okc_k_party_roles_b party1,
1529: okc_k_party_roles_b party2,
1530: okc_contacts cont,
1531: hz_parties hz,
1532: hr_all_organization_units b,
1533: hr_locations_all c
1534: WHERE hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )
1535: AND hdr.sts_code = p_status_code
1536: AND hdr.scs_code IN( 'SERVICE', 'WARRANTY', 'SUBSCRIPTION' )

Line 1576: hr_all_organization_units b,

1572: okc_k_party_roles_b party1,
1573: okc_k_party_roles_b party2,
1574: okc_contacts cont,
1575: hz_parties hz,
1576: hr_all_organization_units b,
1577: hr_locations_all c
1578: WHERE hdr.id = p_contract_hdr_id
1579: AND hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )
1580: AND hdr.sts_code = stat.code

Line 1621: hr_all_organization_units b,

1617: okc_k_party_roles_b party1,
1618: okc_k_party_roles_b party2,
1619: okc_contacts cont,
1620: hz_parties hz,
1621: hr_all_organization_units b,
1622: hr_locations_all c
1623: WHERE hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )
1624: AND hdr.sts_code = p_status_code
1625: AND hdr.scs_code IN( 'SERVICE', 'WARRANTY', 'SUBSCRIPTION' )

Line 1664: hr_all_organization_units b,

1660: okc_k_party_roles_b party1,
1661: okc_k_party_roles_b party2,
1662: okc_contacts cont,
1663: hz_parties hz,
1664: hr_all_organization_units b,
1665: hr_locations_all c
1666: WHERE hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )
1667: AND hdr.sts_code = stat.code
1668: AND stat.ste_code IN ('ENTERED','ACTIVE','SIGNED','HOLD')

Line 1709: hr_all_organization_units b,

1705: okc_k_party_roles_b party1,
1706: okc_k_party_roles_b party2,
1707: okc_contacts cont,
1708: hz_parties hz,
1709: hr_all_organization_units b,
1710: hr_locations_all c
1711: WHERE hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )
1712: AND hdr.sts_code = stat.code
1713: AND stat.ste_code IN ('ENTERED','ACTIVE','SIGNED','HOLD')