APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_INVOICE_TYPES_V

Line 3115: l_format_type okl_invoice_types_v.name%TYPE;

3111: l_lsm_id NUMBER;
3112:
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);

Line 3186: okl_invoice_types_v ity,

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

Line 3209: okl_invoice_types_v ity,

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

Line 3254: okl_invoice_types_v ity,

3250: ilt.name ilt_name,
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

Line 3277: okl_invoice_types_v ity,

3273: ilt.name ilt_name,
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;

Line 3286: ity_id okl_invoice_types_v.id%type,

3282: TYPE inv_format_type IS RECORD (
3283: inf_id okl_invoice_formats_v.id%type,
3284: inf_name okl_invoice_formats_v.name%type,
3285: contract_level_yn okl_invoice_formats_v.contract_level_yn%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,

Line 3287: ity_name okl_invoice_types_v.name%type,

3283: inf_id okl_invoice_formats_v.id%type,
3284: inf_name okl_invoice_formats_v.name%type,
3285: contract_level_yn okl_invoice_formats_v.contract_level_yn%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,

Line 3288: group_asset_yn okl_invoice_types_v.group_asset_yn%type,

3284: inf_name okl_invoice_formats_v.name%type,
3285: contract_level_yn okl_invoice_formats_v.contract_level_yn%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,

Line 3289: group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type,

3285: contract_level_yn okl_invoice_formats_v.contract_level_yn%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,