DBA Data[Home] [Help]

APPS.OKL_LLA_UTIL_PVT dependencies on OKC_LINE_STYLES_B

Line 979: OKC_LINE_STYLES_B B

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

Line 982: OKC_LINE_STYLES_B B

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

Line 1006: OKC_LINE_STYLES_B B

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

Line 1009: OKC_LINE_STYLES_B B

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

Line 1032: OKC_LINE_STYLES_B B

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

Line 1035: OKC_LINE_STYLES_B B

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

Line 1093: OKC_LINE_STYLES_B B

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

Line 1096: OKC_LINE_STYLES_B B

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

Line 1122: OKC_LINE_STYLES_B B

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

Line 1125: OKC_LINE_STYLES_B B

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

Line 1148: OKC_LINE_STYLES_B B

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

Line 1151: OKC_LINE_STYLES_B B

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

Line 1202: , OKC_LINE_STYLES_B LSE_FIN

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

Line 1204: , OKC_LINE_STYLES_B LSE_FA

1200: SELECT FAV.ASSET_NUMBER ASSETNUMBER
1201: FROM OKC_K_LINES_V CLE_FIN
1202: , OKC_LINE_STYLES_B LSE_FIN
1203: , OKC_K_LINES_B CLE_FA
1204: , OKC_LINE_STYLES_B LSE_FA
1205: , OKC_K_ITEMS CIM_FA
1206: , FA_ADDITIONS_B FAV
1207: WHERE CLE_FIN.CLE_ID IS NULL
1208: AND CLE_FIN.id = p_kle_id