DBA Data[Home] [Help]

APPS.OKL_CONS_BILL dependencies on OKL_INVOICE_TYPES_V

Line 986: l_format_type okl_invoice_types_v.name%TYPE;

982: l_lsm_id NUMBER;
983:
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);

Line 1056: okl_invoice_types_v ity,

1052: ilt.sequence_number,
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

Line 1079: okl_invoice_types_v ity,

1075: ilt.id ilt_id,
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