DBA Data[Home] [Help]

APPS.PO_RETROACTIVE_PRICING_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

Line 234: FROM RCV_TRANSACTIONS_INTERFACE RTI

230: AND POR.po_release_id = PORA.po_release_id (+)
231: AND PORA.latest_external_flag (+) = 'Y'
232: --Bug 10011874 Release/SPO should not be updated when there are open receiving transactions
233: AND NOT EXISTS (SELECT 'no pending receiving transactions'
234: FROM RCV_TRANSACTIONS_INTERFACE RTI
235: WHERE RTI.po_line_location_id = POLL.line_location_id
236: AND RTI.transaction_status_code = 'PENDING'
237: )
238: order by por.po_release_id

Line 300: FROM RCV_TRANSACTIONS_INTERFACE RTI

296: AND poha.latest_external_flag (+) = 'Y'
297: AND pol.order_type_lookup_code not in ('RATE', 'FIXED PRICE') -- Bug 3524527
298: --Bug 10011874 Release/SPO should not be updated when there are open receiving transactions
299: AND NOT EXISTS (SELECT 'no pending receiving transactions'
300: FROM RCV_TRANSACTIONS_INTERFACE RTI
301: WHERE RTI.po_line_location_id = POLL.line_location_id
302: AND RTI.transaction_status_code = 'PENDING'
303: )
304: order by poh.po_header_id

Line 343: FROM RCV_TRANSACTIONS_INTERFACE RTI

339: AND POR.po_release_id = PORA.po_release_id (+)
340: AND PORA.latest_external_flag (+) = 'Y'
341: --Bug 10011874 Release/SPO should not be updated when there are open receiving transactions
342: AND NOT EXISTS (SELECT 'no pending receiving transactions'
343: FROM RCV_TRANSACTIONS_INTERFACE RTI
344: WHERE RTI.po_line_location_id = POLL.line_location_id
345: AND RTI.transaction_status_code = 'PENDING'
346: )
347: order by por.po_release_id

Line 403: FROM RCV_TRANSACTIONS_INTERFACE RTI

399: AND poha.latest_external_flag (+) = 'Y'
400: AND pol.order_type_lookup_code not in ('RATE', 'FIXED PRICE') -- Bug 3524527
401: --Bug 10011874 Release/SPO should not be updated when there are open receiving transactions
402: AND NOT EXISTS (SELECT 'no pending receiving transactions'
403: FROM RCV_TRANSACTIONS_INTERFACE RTI
404: WHERE RTI.po_line_location_id = POLL.line_location_id
405: AND RTI.transaction_status_code = 'PENDING'
406: )
407: order by poh.po_header_id