[Home] [Help]
1210: flow.id FLOW_ID,
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
1230: --dkagrawa end
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;
1248: SELECT levels.amount AMOUNT,
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
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
1272: WHERE OBJ.ID= FLOW.CFO_ID