APPS.RCV_ACCRUAL_SV dependencies on RCV_TRANSACTIONS

Line 259: rcv_transactions

255: shipment_line_id,
256: po_line_location_id,
257: parent_transaction_id
258: FROM
259: rcv_transactions
260: WHERE transaction_date <= trunc(p_accrual_cutoff_date)+1
261: START WITH transaction_id = c_transaction_id
262: CONNECT BY parent_transaction_id = PRIOR transaction_id;
263:

Line 322: rcv_transactions

318: transaction_type
319: INTO
320: v_parent_type
321: FROM
322: rcv_transactions
323: WHERE
324: transaction_id = v_parent_id;
325:
326: if v_parent_type = 'ACCEPT' THEN

Line 350: rcv_transactions

346: transaction_type
347: INTO
348: v_parent_type
349: FROM
350: rcv_transactions
351: WHERE
352: transaction_id = v_parent_id;
353:
354: if v_parent_type <> 'ACCEPT' THEN

Line 372: rcv_transactions

368: transaction_type
369: INTO
370: v_parent_type
371: FROM
372: rcv_transactions
373: WHERE
374: transaction_id = v_parent_id;
375:
376: if v_parent_type <> 'REJECT' then

Line 396: rcv_transactions

392: transaction_type,parent_transaction_id
393: INTO
394: v_parent_type,grand_parent_id
395: FROM
396: rcv_transactions
397: WHERE
398: transaction_id = v_parent_id;
399:
400: /*Bug 2272666 Added the no data found exception for the select statement itself

Line 413: rcv_transactions

409: transaction_type
410: INTO
411: grand_parent_type
412: FROM
413: rcv_transactions
414: WHERE
415: transaction_id = grand_parent_id;
416: EXCEPTION
417:

Line 496: rcv_transactions rt

492: ordered_po_qty,
493: billed_txn_qty
494: FROM
495: po_line_locations ps,
496: rcv_transactions rt
497: WHERE
498: rt.transaction_id = top_transaction_id and
499: rt.po_line_location_id = ps.line_location_id;
500: ELSE