DBA Data[Home] [Help]

APPS.JA_CN_CUSTOM_SOURCES dependencies on PO_LINES_ALL

Line 173: FROM PO_LINES_ALL

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

Line 227: FROM PO_LINES_ALL

223: WHERE MCST.LANGUAGE = USERENV('LANG')
224: AND MCST.CATEGORY_SET_NAME = 'Cash Flow Category')
225: AND INVENTORY_ITEM_ID IN(
226: SELECT ITEM_ID
227: FROM PO_LINES_ALL
228: WHERE PO_HEADER_ID = L_PO_HEADER_ID
229: AND PO_LINE_ID = L_PO_LINE_ID
230: )
231: AND ORGANIZATION_ID IN(

Line 408: FROM PO_LINES_ALL

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