DBA Data[Home] [Help]

APPS.POA_EDW_RCV_TXNS_F_C dependencies on RCV_SHIPMENT_LINES

Line 377: FROM RCV_SHIPMENT_LINES rsl,

373: Here RCV_TRANSACTIONS is the base table for the fact */
374:
375: INSERT INTO poa_edw_rcv_txns_inc(primary_key, seq_id)
376: SELECT rcv.transaction_id, l_seq_id
377: FROM RCV_SHIPMENT_LINES rsl,
378: RCV_TRANSACTIONS rcv
379: WHERE rcv.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
380: AND greatest(rcv.last_update_date,
381: rsl.last_update_date)