[Home] [Help]
368: (
369: SELECT
370: EXCISE_INV_NUMBER
371: FROM
372: JAI_CMN_LINES
373: WHERE
374: HEADER_INTERFACE_ID = RHI.HEADER_INTERFACE_ID
375: AND rownum = 1
376: )
378: (
379: SELECT
380: EXCISE_INV_DATE
381: FROM
382: JAI_CMN_LINES
383: WHERE
384: HEADER_INTERFACE_ID = RHI.HEADER_INTERFACE_ID
385: AND rownum = 1
386: )