eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_INVC_LINE_TYPES_V

Line 3117: l_sequence_number okl_invc_line_types_v.sequence_number%TYPE;

3113: l_line_name VARCHAR2(150);
3114: l_ity_id NUMBER;
3115: l_format_type okl_invoice_types_v.name%TYPE;
3116:
3117: l_sequence_number okl_invc_line_types_v.sequence_number%TYPE;
3118: l_cons_line_name VARCHAR2(150);
3119: l_stream_name VARCHAR2(150);
3120: i NUMBER;
3121: l_funct_return VARCHAR2(1);

Line 3187: okl_invc_line_types_v ilt,

3183: ilt.name ilt_name,
3184: sty.name sty_name
3185: FROM okl_invoice_formats_v inf,
3186: okl_invoice_types_v ity,
3187: okl_invc_line_types_v ilt,
3188: okl_invc_frmt_strms_v frs,
3189: okl_strm_type_v sty
3190: WHERE inf.id = p_format_id
3191: AND ity.inf_id = inf.id

Line 3210: okl_invc_line_types_v ilt

3206: ilt.sequence_number,
3207: ilt.name ilt_name
3208: FROM okl_invoice_formats_v inf,
3209: okl_invoice_types_v ity,
3210: okl_invc_line_types_v ilt
3211: WHERE inf.id = p_format_id
3212: AND ity.inf_id = inf.id
3213: AND ilt.ity_id = ity.id
3214: AND inf.ilt_id = ilt.id;

Line 3255: okl_invc_line_types_v ilt,

3251: sty.name sty_name,
3252: frs.sty_id sty_id
3253: FROM okl_invoice_formats_v inf,
3254: okl_invoice_types_v ity,
3255: okl_invc_line_types_v ilt,
3256: okl_invc_frmt_strms_v frs,
3257: okl_strm_type_v sty
3258: WHERE ity.inf_id = inf.id
3259: AND ilt.ity_id = ity.id

Line 3278: okl_invc_line_types_v ilt

3274: 'DEFAULT FORMAT' sty_name,
3275: NULL
3276: FROM okl_invoice_formats_v inf,
3277: okl_invoice_types_v ity,
3278: okl_invc_line_types_v ilt
3279: WHERE ity.inf_id = inf.id
3280: AND ilt.ity_id = ity.id
3281: AND inf.ilt_id = ilt.id;
3282: TYPE inv_format_type IS RECORD (

Line 3290: ilt_id okl_invc_line_types_v.id%type,

3286: ity_id okl_invoice_types_v.id%type,
3287: ity_name okl_invoice_types_v.name%type,
3288: group_asset_yn okl_invoice_types_v.group_asset_yn%type,
3289: group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type,
3290: ilt_id okl_invc_line_types_v.id%type,
3291: sequence_number okl_invc_line_types_v.sequence_number%type,
3292: ilt_name okl_invc_line_types_v.name%type,
3293: sty_name okl_strm_type_v.name%type,
3294: sty_id okl_invc_frmt_strms_v.sty_id%type);

Line 3291: sequence_number okl_invc_line_types_v.sequence_number%type,

3287: ity_name okl_invoice_types_v.name%type,
3288: group_asset_yn okl_invoice_types_v.group_asset_yn%type,
3289: group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type,
3290: ilt_id okl_invc_line_types_v.id%type,
3291: sequence_number okl_invc_line_types_v.sequence_number%type,
3292: ilt_name okl_invc_line_types_v.name%type,
3293: sty_name okl_strm_type_v.name%type,
3294: sty_id okl_invc_frmt_strms_v.sty_id%type);
3295:

Line 3292: ilt_name okl_invc_line_types_v.name%type,

3288: group_asset_yn okl_invoice_types_v.group_asset_yn%type,
3289: group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type,
3290: ilt_id okl_invc_line_types_v.id%type,
3291: sequence_number okl_invc_line_types_v.sequence_number%type,
3292: ilt_name okl_invc_line_types_v.name%type,
3293: sty_name okl_strm_type_v.name%type,
3294: sty_id okl_invc_frmt_strms_v.sty_id%type);
3295:
3296: TYPE inv_format_table IS TABLE OF inv_format_type