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.

APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_INVOICE_TYPES_B

Line 3819: FROM okl_invoice_types_b ity,

3815: TRUNC(xsiB.TRX_DATE) date_consolidated,
3816: NVL(
3817: nvl(
3818: (SELECT ity.id ity_id
3819: FROM okl_invoice_types_b ity,
3820: okl_invc_line_types_b ilt,
3821: okl_invc_frmt_strms frs
3822: WHERE ity.inf_id = inf.id
3823: AND ilt.ity_id = ity.id

Line 3827: from okl_invoice_types_b ity1,

3823: AND ilt.ity_id = ity.id
3824: AND frs.ilt_id = ilt.id
3825: AND tld.sty_id = frs.sty_id),
3826: (select ity1.id
3827: from okl_invoice_types_b ity1,
3828: okl_invc_line_types_b ilt1
3829: where ilt1.id = inf.ilt_id
3830: and ilt1.ity_id = ity1.id)), -1
3831: ) inv_type,

Line 3884: FROM okl_invoice_types_b ity,

3880: xsit.xtrx_private_label private_label,
3881: TRUNC(xsib.TRX_DATE) date_consolidated,
3882: NVL(
3883: NVL((SELECT ity.id ity_id
3884: FROM okl_invoice_types_b ity,
3885: okl_invc_line_types_b ilt,
3886: okl_invc_frmt_strms frs
3887: WHERE ity.inf_id = inf.id
3888: AND ilt.ity_id = ity.id

Line 3891: (select ity1.id from okl_invoice_types_b ity1,

3887: WHERE ity.inf_id = inf.id
3888: AND ilt.ity_id = ity.id
3889: AND frs.ilt_id = ilt.id
3890: AND tld.sty_id = frs.sty_id),
3891: (select ity1.id from okl_invoice_types_b ity1,
3892: okl_invc_line_types_b ilt1
3893: where ilt1.id = inf.ilt_id
3894: and ilt1.ity_id = ity1.id)), -1
3895: ) inv_type, -- bug 5138822

Line 3950: FROM okl_invoice_types_b ity,

3946: xsi.xtrx_private_label private_label,
3947: TRUNC(xsi.TRX_DATE) date_consolidated,
3948: NVL(
3949: NVL((SELECT ity.id ity_id
3950: FROM okl_invoice_types_b ity,
3951: okl_invc_line_types_b ilt,
3952: okl_invc_frmt_strms frs
3953: WHERE ity.inf_id = inf.id
3954: AND ilt.ity_id = ity.id

Line 3957: (select ity1.id from okl_invoice_types_b ity1,

3953: WHERE ity.inf_id = inf.id
3954: AND ilt.ity_id = ity.id
3955: AND frs.ilt_id = ilt.id
3956: AND til.sty_id = frs.sty_id),
3957: (select ity1.id from okl_invoice_types_b ity1,
3958: okl_invc_line_types_b ilt1
3959: where ilt1.id = inf.ilt_id
3960: and ilt1.ity_id = ity1.id)), -1
3961: ) inv_type, -- bug 5138822