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.OE_RETROBILL_PVT dependencies on OE_TRANSACTION_TYPES_TL

Line 633: oe_transaction_types_tl b

629:
630: Cursor Get_CI_Line_Id Is
631: Select customer_trx_line_id --customer_trx_line_id is the invoice_id
632: From ra_customer_trx_lines_all a,
633: oe_transaction_types_tl b
634: Where INTERFACE_LINE_CONTEXT= 'ORDER ENTRY'
635: and INTERFACE_LINE_ATTRIBUTE1=to_char(p_order_number) ----bug5138249
636: and INTERFACE_LINE_ATTRIBUTE2=b.name
637: and INTERFACE_LINE_ATTRIBUTE6=to_char(p_line_id) --bug5138249

Line 4259: oe_transaction_types_tl ott

4255: CURSOR invoice_number is
4256: select rct.trx_number
4257: from ra_customer_trx_lines_all rctl,
4258: ra_customer_trx_all rct,
4259: oe_transaction_types_tl ott
4260: where rctl.INTERFACE_LINE_CONTEXT='ORDER ENTRY' and
4261: rctl.INTERFACE_LINE_ATTRIBUTE1= to_char(l_order_number) and -- Added to_char for bug 9323027
4262: rctl.INTERFACE_LINE_ATTRIBUTE2=ott.name and
4263: rctl. INTERFACE_LINE_ATTRIBUTE6= to_char(l_line_id) and -- Added to_char for bug 9323027