DBA Data[Home] [Help]

APPS.OE_RETROBILL_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 3828: l_trx_number ra_customer_trx_all.trx_number%TYPE;

3824:
3825: l_order_number NUMBER;
3826: l_line_id NUMBER;
3827: l_order_type_id NUMBER;
3828: l_trx_number ra_customer_trx_all.trx_number%TYPE;
3829:
3830: CURSOR invoice_number is
3831: select rct.trx_number
3832: from ra_customer_trx_lines_all rctl,

Line 3833: ra_customer_trx_all rct,

3829:
3830: CURSOR invoice_number is
3831: select rct.trx_number
3832: from ra_customer_trx_lines_all rctl,
3833: ra_customer_trx_all rct,
3834: oe_transaction_types_tl ott
3835: where rctl.INTERFACE_LINE_CONTEXT='ORDER ENTRY' and
3836: rctl.INTERFACE_LINE_ATTRIBUTE1= l_order_number and
3837: rctl.INTERFACE_LINE_ATTRIBUTE2=ott.name and