APPS.JA_CN_CUSTOM_SOURCES dependencies on AP_INVOICE_LINES_ALL

Line 176: FROM AP_INVOICE_LINES_ALL AP

172: SELECT ITEM_ID
173: FROM PO_LINES_ALL
174: WHERE PO_HEADER_ID = (
175: SELECT PO_HEADER_ID
176: FROM AP_INVOICE_LINES_ALL AP
177: WHERE AP.INVOICE_ID=L_INVOICE_ID
178: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
179: AND PO_LINE_ID = (
180: SELECT PO_LINE_ID

Line 181: FROM AP_INVOICE_LINES_ALL AP

177: WHERE AP.INVOICE_ID=L_INVOICE_ID
178: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
179: AND PO_LINE_ID = (
180: SELECT PO_LINE_ID
181: FROM AP_INVOICE_LINES_ALL AP
182: WHERE AP.INVOICE_ID=L_INVOICE_ID
183: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
184: )
185: AND ORGANIZATION_ID IN(

Line 187: FROM AP_INVOICE_LINES_ALL AP

183: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
184: )
185: AND ORGANIZATION_ID IN(
186: SELECT ORG_ID
187: FROM AP_INVOICE_LINES_ALL AP
188: WHERE AP.INVOICE_ID=L_INVOICE_ID
189: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
190: );
191:

Line 201: FROM ap_invoice_lines_all al

197: SELECT PO_HEADER_ID,
198: PO_LINE_ID
199: INTO L_PO_HEADER_ID,
200: L_PO_LINE_ID
201: FROM ap_invoice_lines_all al
202: WHERE RCV_TRANSACTION_ID = (
203: SELECT RCV_TRANSACTION_ID
204: FROM ap_invoice_lines_all ap
205: WHERE ap.invoice_id = P_INVOICE_ID

Line 204: FROM ap_invoice_lines_all ap

200: L_PO_LINE_ID
201: FROM ap_invoice_lines_all al
202: WHERE RCV_TRANSACTION_ID = (
203: SELECT RCV_TRANSACTION_ID
204: FROM ap_invoice_lines_all ap
205: WHERE ap.invoice_id = P_INVOICE_ID
206: AND ap.LINE_NUMBER = L_INVOICE_LINE_NUMBER)
207:
208: AND INVOICE_ID = P_INVOICE_ID

Line 233: FROM AP_INVOICE_LINES_ALL AP

229: AND PO_LINE_ID = L_PO_LINE_ID
230: )
231: AND ORGANIZATION_ID IN(
232: SELECT ORG_ID
233: FROM AP_INVOICE_LINES_ALL AP
234: WHERE AP.INVOICE_ID=L_INVOICE_ID
235: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
236: );
237:

Line 411: FROM AP_INVOICE_LINES_ALL AP

407: SELECT ITEM_ID
408: FROM PO_LINES_ALL
409: WHERE PO_HEADER_ID = (
410: SELECT PO_HEADER_ID
411: FROM AP_INVOICE_LINES_ALL AP
412: WHERE AP.INVOICE_ID=L_INVOICE_ID
413: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
414: AND PO_LINE_ID = (
415: SELECT PO_LINE_ID

Line 416: FROM AP_INVOICE_LINES_ALL AP

412: WHERE AP.INVOICE_ID=L_INVOICE_ID
413: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
414: AND PO_LINE_ID = (
415: SELECT PO_LINE_ID
416: FROM AP_INVOICE_LINES_ALL AP
417: WHERE AP.INVOICE_ID=L_INVOICE_ID
418: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
419: )
420: AND ORGANIZATION_ID IN(

Line 422: FROM AP_INVOICE_LINES_ALL AP

418: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
419: )
420: AND ORGANIZATION_ID IN(
421: SELECT ORG_ID
422: FROM AP_INVOICE_LINES_ALL AP
423: WHERE AP.INVOICE_ID=L_INVOICE_ID
424: AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
425: );
426: