APPS.OKL_CONS_BILL dependencies on OKL_INVC_LINE_TYPES_V

Line 988: l_sequence_number okl_invc_line_types_v.sequence_number%TYPE;

984: l_line_name VARCHAR2(150);
985: l_ity_id NUMBER;
986: l_format_type okl_invoice_types_v.name%TYPE;
987:
988: l_sequence_number okl_invc_line_types_v.sequence_number%TYPE;
989: l_cons_line_name VARCHAR2(150);
990: l_stream_name VARCHAR2(150);
991: i NUMBER;
992: l_funct_return VARCHAR2(1);

Line 1057: okl_invc_line_types_v ilt,

1053: ilt.name ilt_name,
1054: sty.name sty_name
1055: FROM okl_invoice_formats_v inf,
1056: okl_invoice_types_v ity,
1057: okl_invc_line_types_v ilt,
1058: okl_invc_frmt_strms_v frs,
1059: okl_strm_type_v sty
1060: WHERE inf.id = p_format_id
1061: AND ity.inf_id = inf.id

Line 1080: okl_invc_line_types_v ilt

1076: ilt.sequence_number,
1077: ilt.name ilt_name
1078: FROM okl_invoice_formats_v inf,
1079: okl_invoice_types_v ity,
1080: okl_invc_line_types_v ilt
1081: WHERE inf.id = p_format_id
1082: AND ity.inf_id = inf.id
1083: AND ilt.ity_id = ity.id
1084: AND inf.ilt_id = ilt.id;

Line 3017: okl_invc_line_types_v ilt,

3013: l_xlsv_rec.XTRX_CONTRACT,
3014: -- l_xlsv_rec.XTRX_ASSET,
3015: l_xlsv_rec.XTRX_STREAM_GROUP
3016: FROM okl_cnsld_ar_lines_v lln,
3017: okl_invc_line_types_v ilt,
3018: okc_k_headers_b khr
3019: WHERE lln.id = cnr_update_tbl(cnr_tab_idx).lln_id AND
3020: khr.id = lln.khr_id AND
3021: lln.ilt_id = ilt.id(+);