DBA Data[Home] [Help]

APPS.OKL_LLA_UTIL_PVT dependencies on OKC_LINE_STYLES_B

Line 980: OKC_LINE_STYLES_B B

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
984: WHERE CLE_ID = p_kle_id

Line 983: OKC_LINE_STYLES_B B

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
987: AND B.LTY_CODE = 'FREE_FORM2')

Line 1007: OKC_LINE_STYLES_B B

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
1011: WHERE CLE_ID = p_kle_id

Line 1010: OKC_LINE_STYLES_B B

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
1014: AND B.LTY_CODE = 'FREE_FORM2')

Line 1033: OKC_LINE_STYLES_B 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
1037: WHERE CLE_ID = p_kle_id

Line 1036: OKC_LINE_STYLES_B B

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
1040: AND B.LTY_CODE = 'FREE_FORM2')

Line 1094: OKC_LINE_STYLES_B B

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
1098: WHERE CLE_ID = p_kle_id

Line 1097: OKC_LINE_STYLES_B B

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
1101: AND B.LTY_CODE = 'FREE_FORM2')

Line 1123: OKC_LINE_STYLES_B B

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
1127: WHERE CLE_ID = p_kle_id

Line 1126: OKC_LINE_STYLES_B B

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
1130: AND B.LTY_CODE = 'FREE_FORM2')

Line 1149: OKC_LINE_STYLES_B B

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
1153: WHERE CLE_ID = p_kle_id

Line 1152: OKC_LINE_STYLES_B B

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
1156: AND B.LTY_CODE = 'FREE_FORM2')

Line 1203: , OKC_LINE_STYLES_B LSE_FIN

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
1207: , FA_ADDITIONS_B FAV

Line 1205: , OKC_LINE_STYLES_B LSE_FA

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
1207: , FA_ADDITIONS_B FAV
1208: WHERE CLE_FIN.CLE_ID IS NULL
1209: AND CLE_FIN.id = p_kle_id