[Home] [Help]
1211: ql.id LINE_ID,
1212: levels.rate,
1213: ql.value VALUE
1214: FROM okl_cash_flow_objects obj, okl_cash_flows flow, okl_cash_flow_levels levels,
1215: okl_quick_quotes_b qh, okl_quick_quote_lines_b ql
1216: where obj.id= flow.cfo_id
1217: AND flow.id= levels.caf_id
1218: AND qh.id= ql.quick_quote_id
1219: AND obj.source_table='OKL_QUICK_QUOTE_LINES_B'
1215: okl_quick_quotes_b qh, okl_quick_quote_lines_b ql
1216: where obj.id= flow.cfo_id
1217: AND flow.id= levels.caf_id
1218: AND qh.id= ql.quick_quote_id
1219: AND obj.source_table='OKL_QUICK_QUOTE_LINES_B'
1220: AND obj.source_id= ql.id
1221: AND (ql.basis='ASSET_COST' or ql.basis='RENT')
1222: AND qh.id=p_qqh_id;
1223:
1231:
1232:
1233: CURSOR get_oty_code(qql_id IN NUMBER) IS
1234: SELECT oty_code FROM okl_cash_flow_objects
1235: WHERE source_table= 'OKL_QUICK_QUOTE_LINES_B' AND source_id= qql_id;
1236: -- cursor to fetch the quick quote line ids for a particualr quick quote header
1237: CURSOR get_qq_lines(qqh_id IN NUMBER) IS
1238: SELECT id FROM okl_quick_quote_lines_b where quick_quote_id=qqh_id;
1239:
1234: SELECT oty_code FROM okl_cash_flow_objects
1235: WHERE source_table= 'OKL_QUICK_QUOTE_LINES_B' AND source_id= qql_id;
1236: -- cursor to fetch the quick quote line ids for a particualr quick quote header
1237: CURSOR get_qq_lines(qqh_id IN NUMBER) IS
1238: SELECT id FROM okl_quick_quote_lines_b where quick_quote_id=qqh_id;
1239:
1240: -- cursor to fetch the fees and services
1241: /* sosharma 08-Feb-2008 bug 6692055
1242: Modified the cursor query get_line_dtls in OKL_QUICK_QUOTES_PVT.handle_quick_quote, so
1249: levels.number_of_periods NUMBER_OF_PERIODS,
1250: levels.start_date START_DATE,
1251: ql.TYPE TYPE
1252: FROM okl_cash_flow_objects obj, okl_cash_flows flow, okl_cash_flow_levels levels,
1253: okl_quick_quotes_b qh, okl_quick_quote_lines_b ql
1254: where obj.id= flow.cfo_id
1255: AND flow.id= levels.caf_id
1256: AND qh.id= ql.quick_quote_id
1257: AND obj.source_table='OKL_QUICK_QUOTE_LINES_B'
1253: okl_quick_quotes_b qh, okl_quick_quote_lines_b ql
1254: where obj.id= flow.cfo_id
1255: AND flow.id= levels.caf_id
1256: AND qh.id= ql.quick_quote_id
1257: AND obj.source_table='OKL_QUICK_QUOTE_LINES_B'
1258: AND obj.source_id= ql.id
1259: AND ql.type IN ('FEE_EXPENSE','FEE_PAYMENT','INSURANCE','TAX','SERVICE')
1260: AND qh.id=p_qqh_id;
1261: */
1263: SELECT LEVELS.AMOUNT AMOUNT, LEVELS.NUMBER_OF_PERIODS NUMBER_OF_PERIODS,
1264: LEVELS.START_DATE START_DATE, QL.TYPE TYPE
1265: FROM
1266: OKL_QUICK_QUOTES_B QH,
1267: OKL_QUICK_QUOTE_LINES_B QL,
1268: OKL_CASH_FLOW_OBJECTS OBJ,
1269: OKL_CASH_FLOWS FLOW,
1270: OKL_CASH_FLOW_LEVELS LEVELS,
1271: FND_LOOKUPS LKP
1274: AND QH.ID= QL.QUICK_QUOTE_ID
1275: AND LKP.LOOKUP_TYPE = 'OKL_CF_OBJECT_TYPE'
1276: /* The following 3 obj columns are part of the composite index CFO_COMP_I */
1277: AND OBJ.OTY_CODE = LKP.LOOKUP_CODE
1278: AND OBJ.SOURCE_TABLE='OKL_QUICK_QUOTE_LINES_B'
1279: AND OBJ.SOURCE_ID= QL.ID
1280: AND QL.TYPE IN ('FEE_EXPENSE','FEE_PAYMENT','INSURANCE','TAX','SERVICE')
1281: AND QH.ID=p_qqh_id;
1282: /* sosharma end changes */
2216: comments
2217: FROM okl_quick_quotes_v
2218: WHERE id = p_id;
2219:
2220: CURSOR c_qql(p_id IN okl_quick_quote_lines_b.quick_quote_id%TYPE) IS
2221: SELECT id,
2222: object_version_number,
2223: attribute_category,
2224: attribute1,