APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_INVOICE_TYPES_V

Line 3051: l_format_type okl_invoice_types_v.name%TYPE;

3047: l_lsm_id NUMBER;
3048:
3049: l_line_name VARCHAR2(150);
3050: l_ity_id NUMBER;
3051: l_format_type okl_invoice_types_v.name%TYPE;
3052:
3053: l_sequence_number okl_invc_line_types_v.sequence_number%TYPE;
3054: l_cons_line_name VARCHAR2(150);
3055: l_stream_name VARCHAR2(150);

Line 3122: okl_invoice_types_v ity,

3118: ilt.sequence_number,
3119: ilt.name ilt_name,
3120: sty.name sty_name
3121: FROM okl_invoice_formats_v inf,
3122: okl_invoice_types_v ity,
3123: okl_invc_line_types_v ilt,
3124: okl_invc_frmt_strms_v frs,
3125: okl_strm_type_v sty
3126: WHERE inf.id = p_format_id

Line 3145: okl_invoice_types_v ity,

3141: ilt.id ilt_id,
3142: ilt.sequence_number,
3143: ilt.name ilt_name
3144: FROM okl_invoice_formats_v inf,
3145: okl_invoice_types_v ity,
3146: okl_invc_line_types_v ilt
3147: WHERE inf.id = p_format_id
3148: AND ity.inf_id = inf.id
3149: AND ilt.ity_id = ity.id

Line 3190: okl_invoice_types_v ity,

3186: ilt.name ilt_name,
3187: sty.name sty_name,
3188: frs.sty_id sty_id
3189: FROM okl_invoice_formats_v inf,
3190: okl_invoice_types_v ity,
3191: okl_invc_line_types_v ilt,
3192: okl_invc_frmt_strms_v frs,
3193: okl_strm_type_v sty
3194: WHERE ity.inf_id = inf.id

Line 3213: okl_invoice_types_v ity,

3209: ilt.name ilt_name,
3210: 'DEFAULT FORMAT' sty_name,
3211: NULL
3212: FROM okl_invoice_formats_v inf,
3213: okl_invoice_types_v ity,
3214: okl_invc_line_types_v ilt
3215: WHERE ity.inf_id = inf.id
3216: AND ilt.ity_id = ity.id
3217: AND inf.ilt_id = ilt.id;

Line 3222: ity_id okl_invoice_types_v.id%type,

3218: TYPE inv_format_type IS RECORD (
3219: inf_id okl_invoice_formats_v.id%type,
3220: inf_name okl_invoice_formats_v.name%type,
3221: contract_level_yn okl_invoice_formats_v.contract_level_yn%type,
3222: ity_id okl_invoice_types_v.id%type,
3223: ity_name okl_invoice_types_v.name%type,
3224: group_asset_yn okl_invoice_types_v.group_asset_yn%type,
3225: group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type,
3226: ilt_id okl_invc_line_types_v.id%type,

Line 3223: ity_name okl_invoice_types_v.name%type,

3219: inf_id okl_invoice_formats_v.id%type,
3220: inf_name okl_invoice_formats_v.name%type,
3221: contract_level_yn okl_invoice_formats_v.contract_level_yn%type,
3222: ity_id okl_invoice_types_v.id%type,
3223: ity_name okl_invoice_types_v.name%type,
3224: group_asset_yn okl_invoice_types_v.group_asset_yn%type,
3225: group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type,
3226: ilt_id okl_invc_line_types_v.id%type,
3227: sequence_number okl_invc_line_types_v.sequence_number%type,

Line 3224: group_asset_yn okl_invoice_types_v.group_asset_yn%type,

3220: inf_name okl_invoice_formats_v.name%type,
3221: contract_level_yn okl_invoice_formats_v.contract_level_yn%type,
3222: ity_id okl_invoice_types_v.id%type,
3223: ity_name okl_invoice_types_v.name%type,
3224: group_asset_yn okl_invoice_types_v.group_asset_yn%type,
3225: group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type,
3226: ilt_id okl_invc_line_types_v.id%type,
3227: sequence_number okl_invc_line_types_v.sequence_number%type,
3228: ilt_name okl_invc_line_types_v.name%type,

Line 3225: group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type,

3221: contract_level_yn okl_invoice_formats_v.contract_level_yn%type,
3222: ity_id okl_invoice_types_v.id%type,
3223: ity_name okl_invoice_types_v.name%type,
3224: group_asset_yn okl_invoice_types_v.group_asset_yn%type,
3225: group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type,
3226: ilt_id okl_invc_line_types_v.id%type,
3227: sequence_number okl_invc_line_types_v.sequence_number%type,
3228: ilt_name okl_invc_line_types_v.name%type,
3229: sty_name okl_strm_type_v.name%type,