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_LOCATIONS_ALL

Line 1397: hr_locations_all c

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
1401: AND hdr.scs_code IN( 'SERVICE', 'WARRANTY', 'SUBSCRIPTION' )

Line 1442: hr_locations_all c

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
1446: AND hdr.scs_code IN( 'SERVICE', 'WARRANTY', 'SUBSCRIPTION' )

Line 1487: hr_locations_all c

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
1491: AND stat.ste_code IN ('ENTERED','ACTIVE','SIGNED','HOLD')

Line 1533: hr_locations_all c

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' )
1537: AND hdr.template_yn = 'N'

Line 1577: hr_locations_all c

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
1581: AND stat.ste_code IN ('ENTERED','ACTIVE','SIGNED','HOLD')

Line 1622: hr_locations_all c

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' )
1626: AND hdr.template_yn = 'N'

Line 1665: hr_locations_all c

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')
1669: AND hdr.scs_code IN( 'SERVICE', 'WARRANTY', 'SUBSCRIPTION' )

Line 1710: hr_locations_all c

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')
1714: AND hdr.scs_code IN( 'SERVICE', 'WARRANTY', 'SUBSCRIPTION' )