DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on PO_HEADERS_ALL

Line 379: po_headers_all po WHERE

375: END IF;
376:
377: BEGIN
378: SELECT COUNT(1) INTO l_count FROM
379: po_headers_all po WHERE
380: po.po_header_id = p_mtl_trx_tbl(i).transaction_source_id AND
381: NVL(po.START_DATE_ACTIVE, SYSDATE - 1) <= Sysdate AND
382: NVL(po.END_DATE_ACTIVE, SYSDATE + 1) > SYSDATE AND ENABLED_FLAG = 'Y';
383:

Line 1035: po_headers_all po, rcv_transactions rcv WHERE

1031: END IF;
1032:
1033: BEGIN
1034: SELECT COUNT(1) INTO l_count FROM
1035: po_headers_all po, rcv_transactions rcv WHERE
1036: po.po_header_id = rcv.po_header_id AND
1037: po.po_header_id = p_mtl_trx_tbl(i).transaction_source_id AND
1038: rcv.transaction_id = p_mtl_trx_tbl(i).rcv_transaction_id AND
1039: NVL(po.START_DATE_ACTIVE, SYSDATE - 1) <= Sysdate AND