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 3755: FROM okl_invoice_types_b ity,

3751: TRUNC(xsiB.TRX_DATE) date_consolidated,
3752: NVL(
3753: nvl(
3754: (SELECT ity.id ity_id
3755: FROM okl_invoice_types_b ity,
3756: okl_invc_line_types_b ilt,
3757: okl_invc_frmt_strms frs
3758: WHERE ity.inf_id = inf.id
3759: AND ilt.ity_id = ity.id

Line 3763: from okl_invoice_types_b ity1,

3759: AND ilt.ity_id = ity.id
3760: AND frs.ilt_id = ilt.id
3761: AND tld.sty_id = frs.sty_id),
3762: (select ity1.id
3763: from okl_invoice_types_b ity1,
3764: okl_invc_line_types_b ilt1
3765: where ilt1.id = inf.ilt_id
3766: and ilt1.ity_id = ity1.id)), -1
3767: ) inv_type,

Line 3820: FROM okl_invoice_types_b ity,

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

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

3823: WHERE ity.inf_id = inf.id
3824: AND ilt.ity_id = ity.id
3825: AND frs.ilt_id = ilt.id
3826: AND tld.sty_id = frs.sty_id),
3827: (select ity1.id 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, -- bug 5138822

Line 3886: FROM okl_invoice_types_b ity,

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

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

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