APPS.JA_CN_CUSTOM_SOURCES dependencies on AP_INVOICE_LINES_ALL

Line 238: FROM AP_INVOICE_LINES_ALL AP

234: SELECT ITEM_ID
235: FROM PO_LINES_ALL
236: WHERE PO_HEADER_ID = (
237: SELECT PO_HEADER_ID
238: FROM AP_INVOICE_LINES_ALL AP
239: WHERE AP.INVOICE_ID=L_INVOICE_ID
240: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
241: AND PO_LINE_ID = (
242: SELECT PO_LINE_ID

Line 243: FROM AP_INVOICE_LINES_ALL AP

239: WHERE AP.INVOICE_ID=L_INVOICE_ID
240: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
241: AND PO_LINE_ID = (
242: SELECT PO_LINE_ID
243: FROM AP_INVOICE_LINES_ALL AP
244: WHERE AP.INVOICE_ID=L_INVOICE_ID
245: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
246: )
247: AND ORGANIZATION_ID IN(

Line 249: FROM AP_INVOICE_LINES_ALL AP

245: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
246: )
247: AND ORGANIZATION_ID IN(
248: SELECT ORG_ID
249: FROM AP_INVOICE_LINES_ALL AP
250: WHERE AP.INVOICE_ID=L_INVOICE_ID
251: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
252: );
253:

Line 263: FROM ap_invoice_lines_all al

259: SELECT PO_HEADER_ID,
260: PO_LINE_ID
261: INTO L_PO_HEADER_ID,
262: L_PO_LINE_ID
263: FROM ap_invoice_lines_all al
264: WHERE RCV_TRANSACTION_ID = (
265: SELECT RCV_TRANSACTION_ID
266: FROM ap_invoice_lines_all ap
267: WHERE ap.invoice_id = P_INVOICE_ID

Line 266: FROM ap_invoice_lines_all ap

262: L_PO_LINE_ID
263: FROM ap_invoice_lines_all al
264: WHERE RCV_TRANSACTION_ID = (
265: SELECT RCV_TRANSACTION_ID
266: FROM ap_invoice_lines_all ap
267: WHERE ap.invoice_id = P_INVOICE_ID
268: AND ap.LINE_NUMBER = L_INVOICE_LINE_NUMBER)
269:
270: AND INVOICE_ID = P_INVOICE_ID

Line 295: FROM AP_INVOICE_LINES_ALL AP

291: AND PO_LINE_ID = L_PO_LINE_ID
292: )
293: AND ORGANIZATION_ID IN(
294: SELECT ORG_ID
295: FROM AP_INVOICE_LINES_ALL AP
296: WHERE AP.INVOICE_ID=L_INVOICE_ID
297: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
298: );
299:

Line 473: FROM AP_INVOICE_LINES_ALL AP

469: SELECT ITEM_ID
470: FROM PO_LINES_ALL
471: WHERE PO_HEADER_ID = (
472: SELECT PO_HEADER_ID
473: FROM AP_INVOICE_LINES_ALL AP
474: WHERE AP.INVOICE_ID=L_INVOICE_ID
475: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
476: AND PO_LINE_ID = (
477: SELECT PO_LINE_ID

Line 478: FROM AP_INVOICE_LINES_ALL AP

474: WHERE AP.INVOICE_ID=L_INVOICE_ID
475: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
476: AND PO_LINE_ID = (
477: SELECT PO_LINE_ID
478: FROM AP_INVOICE_LINES_ALL AP
479: WHERE AP.INVOICE_ID=L_INVOICE_ID
480: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
481: )
482: AND ORGANIZATION_ID IN(

Line 484: FROM AP_INVOICE_LINES_ALL AP

480: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
481: )
482: AND ORGANIZATION_ID IN(
483: SELECT ORG_ID
484: FROM AP_INVOICE_LINES_ALL AP
485: WHERE AP.INVOICE_ID=L_INVOICE_ID
486: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
487: );
488: