DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on RCV_TRANSACTIONS

Line 569: FROM oe_drop_ship_sources odss, rcv_transactions RT

565: -- get the start active and end active dates and make sure that
566: -- transaction date is between them.
567: BEGIN
568: SELECT odss.header_id INTO l_so_header_id
569: FROM oe_drop_ship_sources odss, rcv_transactions RT
570: WHERE odss.line_location_id = rt.po_line_location_id AND
571: rt.transaction_id = p_mtl_trx_tbl(i).rcv_transaction_id
572: GROUP BY odss.header_id;
573: EXCEPTION

Line 1017: po_headers_all po, rcv_transactions rcv WHERE

1013: END IF;
1014:
1015: BEGIN
1016: SELECT COUNT(1) INTO l_count FROM
1017: po_headers_all po, rcv_transactions rcv WHERE
1018: po.po_header_id = rcv.po_header_id AND
1019: po.po_header_id = p_mtl_trx_tbl(i).transaction_source_id AND
1020: rcv.transaction_id = p_mtl_trx_tbl(i).rcv_transaction_id AND
1021: NVL(po.START_DATE_ACTIVE, SYSDATE - 1) <= Sysdate AND