DBA Data[Home] [Help]

APPS.JAI_CREDIT_CHECK_PKG dependencies on JAI_OM_OE_RMA_LINES

Line 305: JAI_OM_OE_RMA_LINES JL

301: ,OL.LINE_CATEGORY_CODE LINE_CATEGORY_CODE
302: ,JL.RMA_LINE_NUMBER LINE_NUMBER
303: ,NVL(OL.TAX_VALUE,0) TAX_VALUE
304: FROM OE_ORDER_LINES OL,
305: JAI_OM_OE_RMA_LINES JL
306: WHERE OL.HEADER_ID = pn_header_id
307: AND OL.HEADER_ID = JL.RMA_HEADER_ID
308: AND OL.LINE_ID = JL.RMA_LINE_ID
309: AND OL.FLOW_STATUS_CODE not in ('CANCELLED','SHIPPED','FULFILLED','CLOSED')