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 OKC_STATUSES_B

Line 929: FROM okc_statuses_b

925:
926: FUNCTION def_sts_code(p_ste_code VARCHAR2) RETURN VARCHAR2 IS
927: CURSOR get_def_sts_code_csr IS
928: SELECT code
929: FROM okc_statuses_b
930: WHERE ste_code = p_ste_code
931: AND default_yn = 'Y';
932: get_def_sts_code_rec get_def_sts_code_csr%ROWTYPE;
933: BEGIN

Line 945: FROM okc_statuses_b

941:
942: FUNCTION get_ste_code(p_sts_code VARCHAR2) RETURN VARCHAR2 IS
943: CURSOR get_ste_code_csr IS
944: SELECT ste_code
945: FROM okc_statuses_b
946: WHERE code = p_sts_code;
947: get_ste_code_rec get_ste_code_csr%ROWTYPE;
948: BEGIN
949:

Line 1167: okc_statuses_b stat,

1163: ,hdr.authoring_org_id,hdr.inv_organization_id, party1.object1_id1
1164: ,Party2.id,hz.party_name, hzl.country, hzl.state
1165: ,cont.id,cont.object1_id1,cont.start_date,hdr.sts_code
1166: FROM OKC_K_HEADERS_B hdr,
1167: okc_statuses_b stat,
1168: okc_k_party_roles_b party1,
1169: okc_k_party_roles_b party2,
1170: okc_contacts cont,
1171: hz_parties hz,

Line 1238: okc_statuses_b stat,

1234: ,hdr.authoring_org_id,hdr.inv_organization_id, party1.object1_id1
1235: ,Party2.id,hz.party_name, hzl.country, hzl.state
1236: ,cont.id,cont.object1_id1,cont.start_date,hdr.sts_code
1237: FROM OKC_K_HEADERS_B hdr,
1238: okc_statuses_b stat,
1239: okc_k_party_roles_b party1,
1240: okc_k_party_roles_b party2,
1241: okc_contacts cont,
1242: hz_parties hz,

Line 1307: okc_statuses_b stat,

1303: ,hdr.authoring_org_id,hdr.inv_organization_id, party1.object1_id1
1304: ,Party2.id,hz.party_name, hzl.country, hzl.state
1305: ,cont.id,cont.object1_id1,cont.start_date,hdr.sts_code
1306: FROM OKC_K_HEADERS_B hdr,
1307: okc_statuses_b stat,
1308: okc_k_party_roles_b party1,
1309: okc_k_party_roles_b party2,
1310: okc_contacts cont,
1311: hz_parties hz,

Line 1344: okc_statuses_b stat,

1340: ,hdr.authoring_org_id,hdr.inv_organization_id, party1.object1_id1
1341: ,Party2.id,hz.party_name, hzl.country, hzl.state
1342: ,cont.id,cont.object1_id1,cont.start_date,hdr.sts_code
1343: FROM OKC_K_HEADERS_B hdr,
1344: okc_statuses_b stat,
1345: okc_k_party_roles_b party1,
1346: okc_k_party_roles_b party2,
1347: okc_contacts cont,
1348: hz_parties hz,

Line 1481: okc_statuses_b stat,

1477: cont.object1_id1,
1478: cont.start_date,
1479: hdr.sts_code
1480: FROM okc_k_headers_b hdr,
1481: okc_statuses_b stat,
1482: okc_k_party_roles_b party1,
1483: okc_k_party_roles_b party2,
1484: okc_contacts cont,
1485: hz_parties hz,

Line 1571: okc_statuses_b stat,

1567: cont.object1_id1,
1568: cont.start_date,
1569: hdr.sts_code
1570: FROM okc_k_headers_b hdr,
1571: okc_statuses_b stat,
1572: okc_k_party_roles_b party1,
1573: okc_k_party_roles_b party2,
1574: okc_contacts cont,
1575: hz_parties hz,

Line 1659: okc_statuses_b stat,

1655: cont.object1_id1,
1656: cont.start_date,
1657: hdr.sts_code
1658: FROM okc_k_headers_b hdr,
1659: okc_statuses_b stat,
1660: okc_k_party_roles_b party1,
1661: okc_k_party_roles_b party2,
1662: okc_contacts cont,
1663: hz_parties hz,

Line 1704: okc_statuses_b stat,

1700: cont.object1_id1,
1701: cont.start_date,
1702: hdr.sts_code
1703: FROM okc_k_headers_b hdr,
1704: okc_statuses_b stat,
1705: okc_k_party_roles_b party1,
1706: okc_k_party_roles_b party2,
1707: okc_contacts cont,
1708: hz_parties hz,