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_ALL

Line 4253: l_trx_number ra_customer_trx_all.trx_number%TYPE;

4249:
4250: l_order_number NUMBER;
4251: l_line_id NUMBER;
4252: l_order_type_id NUMBER;
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,

Line 4258: ra_customer_trx_all rct,

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
4262: rctl.INTERFACE_LINE_ATTRIBUTE2=ott.name and