DBA Data[Home] [Help]

APPS.AP_APPROVAL_PKG dependencies on RCV_TRANSACTIONS

Line 2129: (SELECT 1 FROM AP_INVOICE_DISTRIBUTIONS aid, RCV_TRANSACTIONS rt

2125: /* SELECT 'Y'
2126: INTO l_lcm_used
2127: FROM DUAL
2128: WHERE EXISTS
2129: (SELECT 1 FROM AP_INVOICE_DISTRIBUTIONS aid, RCV_TRANSACTIONS rt
2130: WHERE aid.invoice_id = l_invoice_id
2131: AND aid.rcv_transaction_id = rt.transaction_id
2132: AND rt.lcm_shipment_line_id IS NOT NULL
2133: AND aid.match_status_flag = 'S'); */

Line 2141: RCV_TRANSACTIONS rt

2137: FROM DUAL
2138: WHERE EXISTS
2139: (SELECT 1
2140: FROM AP_INVOICE_DISTRIBUTIONS_ALL aid,
2141: RCV_TRANSACTIONS rt
2142: WHERE aid.invoice_id = l_invoice_id
2143: AND aid.rcv_transaction_id = rt.transaction_id
2144: AND rt.lcm_shipment_line_id IS NOT NULL
2145: AND aid.match_status_flag = 'S'

Line 2151: RCV_TRANSACTIONS rt,

2147: UNION ALL
2148:
2149: SELECT 1
2150: FROM AP_INVOICE_DISTRIBUTIONS_ALL aid,
2151: RCV_TRANSACTIONS rt,
2152: AP_INVOICE_DISTRIBUTIONS_ALL aid2
2153: WHERE aid.invoice_id = l_invoice_id
2154: AND aid.corrected_invoice_dist_id = aid2.invoice_distribution_id
2155: AND aid2.rcv_transaction_id = rt.transaction_id