DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKL_INVOICE_TYPES_V

Line 144: okl_invoice_types_v ity,

140: ity.group_by_contract_yn, -- Provide Contract Details
141: ity.group_asset_yn, -- Combine Assets
142: inf.name -- invoice group
143: FROM okl_invoice_formats_v inf,
144: okl_invoice_types_v ity,
145: okl_invc_line_types_v ilt,
146: okl_invc_frmt_strms_v frs,
147: okl_strm_type_v sty
148: WHERE inf.id = ity.inf_id

Line 161: okl_invoice_types_v ity,

157: ity.group_by_contract_yn, -- Provide Contract Details
158: ity.group_asset_yn, -- Combine Assets
159: inf.name -- invoice group
160: FROM okl_invoice_formats_v inf,
161: okl_invoice_types_v ity,
162: okl_invc_line_types_v ilt
163: WHERE inf.id = ity.inf_id
164: AND ity.inf_id = p_format_id
165: AND ilt.ity_id = ity.id;

Line 906: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;

902: --end: | 02-APR-07 cklee R12 Billing enhancement project |
903: ,l_trx_lines_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_line_tbl_type)
904: IS
905:
906: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
907: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
908: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
909: l_invoice_group okl_invoice_formats_v.name%type;
910: l_khr_id okc_k_headers_b.id%type;

Line 907: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;

903: ,l_trx_lines_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_line_tbl_type)
904: IS
905:
906: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
907: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
908: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
909: l_invoice_group okl_invoice_formats_v.name%type;
910: l_khr_id okc_k_headers_b.id%type;
911: x_tax_det_rec OKL_PROCESS_SALES_TAX_PVT.tax_det_rec_type;

Line 1666: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;

1662: l_rev_rec_basis okl_strm_type_b.accrual_yn%type;
1663: l_org_id NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
1664: l_use_inv_org VARCHAR2(10) := NULL;
1665:
1666: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1667: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1668: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1669: l_invoice_group okl_invoice_formats_v.name%type;
1670: l_khr_id okc_k_headers_b.id%type;

Line 1667: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;

1663: l_org_id NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
1664: l_use_inv_org VARCHAR2(10) := NULL;
1665:
1666: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1667: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1668: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1669: l_invoice_group okl_invoice_formats_v.name%type;
1670: l_khr_id okc_k_headers_b.id%type;
1671: