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 RA_CUSTOMER_TRX_LINES_ALL

Line 632: From ra_customer_trx_lines_all a,

628: Return Number As
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

Line 4257: from ra_customer_trx_lines_all rctl,

4253: l_trx_number ra_customer_trx_all.trx_number%TYPE;
4254:
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