APPS.OKL_LLA_UTIL_PVT dependencies on OKC_K_LINES_V

Line 979: FROM OKC_K_LINES_V A,

975: FROM HZ_LOCATIONS HL,
976: CSI_ITEM_INSTANCES CSI,
977: OKC_K_ITEMS CIM
978: WHERE CIM.CLE_ID = (SELECT A.ID
979: FROM OKC_K_LINES_V A,
980: OKC_LINE_STYLES_B B
981: WHERE CLE_ID = (SELECT A.ID
982: FROM OKC_K_LINES_V A,
983: OKC_LINE_STYLES_B B

Line 982: FROM OKC_K_LINES_V A,

978: WHERE CIM.CLE_ID = (SELECT A.ID
979: FROM OKC_K_LINES_V A,
980: OKC_LINE_STYLES_B B
981: WHERE CLE_ID = (SELECT A.ID
982: FROM OKC_K_LINES_V A,
983: OKC_LINE_STYLES_B B
984: WHERE CLE_ID = p_kle_id
985: AND A.LSE_ID = B.ID
986: AND A.dnz_chr_id = p_khr_id

Line 1006: FROM OKC_K_LINES_V A,

1002: HZ_PARTY_SITES HPS,
1003: CSI_ITEM_INSTANCES CSI,
1004: OKC_K_ITEMS CIM
1005: WHERE CIM.CLE_ID = (SELECT A.ID
1006: FROM OKC_K_LINES_V A,
1007: OKC_LINE_STYLES_B B
1008: WHERE CLE_ID = (SELECT A.ID
1009: FROM OKC_K_LINES_V A,
1010: OKC_LINE_STYLES_B B

Line 1009: FROM OKC_K_LINES_V A,

1005: WHERE CIM.CLE_ID = (SELECT A.ID
1006: FROM OKC_K_LINES_V A,
1007: OKC_LINE_STYLES_B B
1008: WHERE CLE_ID = (SELECT A.ID
1009: FROM OKC_K_LINES_V A,
1010: OKC_LINE_STYLES_B B
1011: WHERE CLE_ID = p_kle_id
1012: AND A.LSE_ID = B.ID
1013: AND A.dnz_chr_id = p_khr_id

Line 1032: FROM OKC_K_LINES_V A,

1028: FROM OKX_PARTY_SITE_USES_V B
1029: WHERE B.ID1 = (SELECT A.OBJECT_ID1_NEW
1030: FROM OKL_TXL_ITM_INSTS_V A
1031: WHERE A.KLE_ID = (SELECT A.ID
1032: FROM OKC_K_LINES_V A,
1033: OKC_LINE_STYLES_B B
1034: WHERE CLE_ID = (SELECT A.ID
1035: FROM OKC_K_LINES_V A,
1036: OKC_LINE_STYLES_B B

Line 1035: FROM OKC_K_LINES_V A,

1031: WHERE A.KLE_ID = (SELECT A.ID
1032: FROM OKC_K_LINES_V A,
1033: OKC_LINE_STYLES_B B
1034: WHERE CLE_ID = (SELECT A.ID
1035: FROM OKC_K_LINES_V A,
1036: OKC_LINE_STYLES_B B
1037: WHERE CLE_ID = p_kle_id
1038: AND A.LSE_ID = B.ID
1039: AND A.dnz_chr_id = p_khr_id

Line 1093: FROM OKC_K_LINES_V A,

1089: OKC_K_ITEMS CIM,
1090: hz_party_site_uses psu,
1091: hz_party_sites hps
1092: WHERE CIM.CLE_ID in (SELECT A.ID
1093: FROM OKC_K_LINES_V A,
1094: OKC_LINE_STYLES_B B
1095: WHERE CLE_ID in (SELECT A.ID
1096: FROM OKC_K_LINES_V A,
1097: OKC_LINE_STYLES_B B

Line 1096: FROM OKC_K_LINES_V A,

1092: WHERE CIM.CLE_ID in (SELECT A.ID
1093: FROM OKC_K_LINES_V A,
1094: OKC_LINE_STYLES_B B
1095: WHERE CLE_ID in (SELECT A.ID
1096: FROM OKC_K_LINES_V A,
1097: OKC_LINE_STYLES_B B
1098: WHERE CLE_ID = p_kle_id
1099: AND A.LSE_ID = B.ID
1100: AND A.dnz_chr_id = p_khr_id

Line 1122: FROM OKC_K_LINES_V A,

1118: HZ_PARTY_SITE_USES PSU,
1119: CSI_ITEM_INSTANCES CSI,
1120: OKC_K_ITEMS CIM
1121: WHERE CIM.CLE_ID in (SELECT A.ID
1122: FROM OKC_K_LINES_V A,
1123: OKC_LINE_STYLES_B B
1124: WHERE CLE_ID in (SELECT A.ID
1125: FROM OKC_K_LINES_V A,
1126: OKC_LINE_STYLES_B B

Line 1125: FROM OKC_K_LINES_V A,

1121: WHERE CIM.CLE_ID in (SELECT A.ID
1122: FROM OKC_K_LINES_V A,
1123: OKC_LINE_STYLES_B B
1124: WHERE CLE_ID in (SELECT A.ID
1125: FROM OKC_K_LINES_V A,
1126: OKC_LINE_STYLES_B B
1127: WHERE CLE_ID = p_kle_id
1128: AND A.LSE_ID = B.ID
1129: AND A.dnz_chr_id = p_khr_id

Line 1148: FROM OKC_K_LINES_V A,

1144: CURSOR l_get_nonbooked_Astloc_csr IS
1145: SELECT A.OBJECT_ID1_NEW
1146: FROM OKL_TXL_ITM_INSTS_V A
1147: WHERE A.KLE_ID IN (SELECT A.ID
1148: FROM OKC_K_LINES_V A,
1149: OKC_LINE_STYLES_B B
1150: WHERE CLE_ID IN (SELECT A.ID
1151: FROM OKC_K_LINES_V A,
1152: OKC_LINE_STYLES_B B

Line 1151: FROM OKC_K_LINES_V A,

1147: WHERE A.KLE_ID IN (SELECT A.ID
1148: FROM OKC_K_LINES_V A,
1149: OKC_LINE_STYLES_B B
1150: WHERE CLE_ID IN (SELECT A.ID
1151: FROM OKC_K_LINES_V A,
1152: OKC_LINE_STYLES_B B
1153: WHERE CLE_ID = p_kle_id
1154: AND A.LSE_ID = B.ID
1155: AND A.dnz_chr_id = p_khr_id

Line 1202: FROM OKC_K_LINES_V CLE_FIN

1198: WHERE ID = p_khr_id;
1199:
1200: CURSOR l_get_booked_astnum_csr IS
1201: SELECT FAV.ASSET_NUMBER ASSETNUMBER
1202: FROM OKC_K_LINES_V CLE_FIN
1203: , OKC_LINE_STYLES_B LSE_FIN
1204: , OKC_K_LINES_B CLE_FA
1205: , OKC_LINE_STYLES_B LSE_FA
1206: , OKC_K_ITEMS CIM_FA