DBA Data[Home] [Help]

APPS.JA_CN_CUSTOM_SOURCES dependencies on PO_LINES_ALL

Line 235: FROM PO_LINES_ALL

231: WHERE MCST.LANGUAGE = USERENV('LANG')
232: AND MCST.CATEGORY_SET_NAME = 'Cash Flow Category')
233: AND INVENTORY_ITEM_ID IN(
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

Line 289: FROM PO_LINES_ALL

285: WHERE MCST.LANGUAGE = USERENV('LANG')
286: AND MCST.CATEGORY_SET_NAME = 'Cash Flow Category')
287: AND INVENTORY_ITEM_ID IN(
288: SELECT ITEM_ID
289: FROM PO_LINES_ALL
290: WHERE PO_HEADER_ID = L_PO_HEADER_ID
291: AND PO_LINE_ID = L_PO_LINE_ID
292: )
293: AND ORGANIZATION_ID IN(

Line 470: FROM PO_LINES_ALL

466: WHERE MCST.LANGUAGE = USERENV('LANG')
467: AND MCST.CATEGORY_SET_NAME = 'Cash Flow Category')
468: AND INVENTORY_ITEM_ID IN(
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