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_ENT_UTIL_PVT dependencies on OKC_K_ITEMS

Line 596: OKC_K_ITEMS ITM,

592: CURSOR l_pdt_csr IS
593: SELECT PDT.ID1,
594: PDT.QUANTITY
595: FROM OKC_K_LINES_B LIN,
596: OKC_K_ITEMS ITM,
597: OKX_CUSTOMER_PRODUCTS_V PDT
598: WHERE LIN.ID = ITM.CLE_ID
599: AND ITM.OBJECT1_ID1 = PDT.ID1
600: AND ITM.OBJECT1_ID2 = PDT.ID2

Line 627: OKC_K_ITEMS ITM,

623: CUS.NAME,
624: PDT.INSTALL_SITE_USE_ID,
625: SIT.NAME PARTY_SITE_NAME
626: FROM OKC_K_LINES_B LIN,
627: OKC_K_ITEMS ITM,
628: OKX_CUSTOMER_PRODUCTS_V PDT,
629: OKX_CUSTOMER_ACCOUNTS_V CUS,
630: OKX_PARTIES_V PTY,
631: OKX_PARTY_SITES_V SIT --OKX_PARTY_SITE_USES_V SIT

Line 646: OKC_K_ITEMS ITM,

642: CUS.NAME cusname,
643: PDT.install_location_id install_location_id, --PDT.INSTALL_SITE_USE_ID,
644: SIT.NAME PARTY_SITE_NAME
645: FROM OKC_K_LINES_B LIN,
646: OKC_K_ITEMS ITM,
647: CSI_ITEM_INSTANCES PDT, --OKX_CUSTOMER_PRODUCTS_V PDT,
648: OKX_CUSTOMER_ACCOUNTS_V CUS,
649: OKX_PARTIES_V PTY,
650: OKX_PARTY_SITES_V SIT --OKX_PARTY_SITE_USES_V

Line 698: OKC_K_ITEMS IT,

694: SELECT SY.ID1,
695: SY.NAME
696: FROM OKC_K_HEADERS_B HD,
697: OKC_K_LINES_B KL,
698: OKC_K_ITEMS IT,
699: OKX_SYSTEMS_V SY
700: WHERE HD.ID = KL.DNZ_CHR_ID
701: AND KL.ID = IT.CLE_ID
702: AND IT.OBJECT1_ID1 = SY.ID1

Line 729: OKC_K_ITEMS IT,

725: SELECT SY.ID1,
726: SY.NAME
727: FROM OKC_K_HEADERS_B HD,
728: OKC_K_LINES_B KL,
729: OKC_K_ITEMS IT,
730: -- OKC_RULE_GROUPS_B RG,
731: -- OKC_RULES_B RL,
732: OKX_SYSTEMS_V SY
733: WHERE HD.ID = KL.DNZ_CHR_ID

Line 776: OKC_K_ITEMS I,

772: CURSOR l_inv_csr IS
773: SELECT V.ID1,
774: V.DESCRIPTION
775: FROM OKC_K_LINES_B L,
776: OKC_K_ITEMS I,
777: OKX_SYSTEM_ITEMS_V V,
778: OKC_K_HEADERS_B H
779: WHERE L.ID = I.CLE_ID
780: AND I.OBJECT1_ID1 = V.ID1

Line 806: OKC_K_ITEMS I,

802: CURSOR l_inv_csr IS
803: SELECT V.ID1,
804: V.DESCRIPTION
805: FROM OKC_K_LINES_B L,
806: OKC_K_ITEMS I,
807: OKX_SYSTEM_ITEMS_V V,
808: OKC_K_HEADERS_B H
809: WHERE L.ID = I.CLE_ID
810: AND I.OBJECT1_ID1 = V.ID1

Line 975: OKC_K_ITEMS IT,

971: IS
972: CURSOR l_pty_csr IS
973: SELECT IT.OBJECT1_ID1, PY.NAME
974: FROM OKC_K_LINES_B KL,
975: OKC_K_ITEMS IT,
976: OKX_PARTIES_V PY
977: WHERE KL.ID = IT.CLE_ID
978: AND IT.OBJECT1_ID1 = PY.ID1
979: AND IT.OBJECT1_ID2 = PY.ID2

Line 1001: OKC_K_ITEMS IT,

997: IS
998: CURSOR l_cust_csr IS
999: SELECT IT.OBJECT1_ID1, CT.NAME
1000: FROM OKC_K_LINES_B KL,
1001: OKC_K_ITEMS IT,
1002: OKX_CUSTOMER_ACCOUNTS_V CT
1003: WHERE KL.ID = IT.CLE_ID
1004: AND IT.OBJECT1_ID1 = CT.ID1
1005: AND IT.OBJECT1_ID2 = CT.ID2

Line 1026: OKC_K_ITEMS IT,

1022: IS
1023: CURSOR l_site_csr IS
1024: SELECT IT.OBJECT1_ID1, SI.NAME LOCATION
1025: FROM OKC_K_LINES_B KL,
1026: OKC_K_ITEMS IT,
1027: OKX_CUST_SITE_USES_V SI
1028: WHERE KL.ID = IT.CLE_ID
1029: AND IT.OBJECT1_ID1 = SI.ID1
1030: AND IT.OBJECT1_ID2 = SI.ID2