DBA Data[Home] [Help]

APPS.AP_APXCRRCR_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 291: AP_INVOICE_DISTRIBUTIONS D1

287: WHERE exists (
288: SELECT
289: 'Invoice has been approved'
290: FROM
291: AP_INVOICE_DISTRIBUTIONS D1
292: WHERE D1.INVOICE_ID = C_INVOICE_ID )
293: AND ( ( NVL(FP.PURCH_ENCUMBRANCE_FLAG
294: ,'N') = 'N'
295: AND not exists (

Line 299: AP_INVOICE_DISTRIBUTIONS D2

295: AND not exists (
296: SELECT
297: 'Invoice is not fully approved'
298: FROM
299: AP_INVOICE_DISTRIBUTIONS D2
300: WHERE D2.INVOICE_ID = C_INVOICE_ID
301: AND NVL(D2.MATCH_STATUS_FLAG
302: ,'N') = 'N' ) )
303: OR ( NVL(FP.PURCH_ENCUMBRANCE_FLAG

Line 309: AP_INVOICE_DISTRIBUTIONS D3

305: AND not exists (
306: SELECT
307: 'Invoice is not fully approved'
308: FROM
309: AP_INVOICE_DISTRIBUTIONS D3
310: WHERE D3.INVOICE_ID = C_INVOICE_ID
311: AND NVL(D3.MATCH_STATUS_FLAG
312: ,'N') <> 'A' ) ) ) ) ) );
313: IF STATUS IS NOT NULL THEN