DBA Data[Home] [Help]

APPS.JA_JAIN23P2_XMLP_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 737: JAI_CMN_RG_23AC_I_TRXS RG23_1

733: SELECT
734: RG23_1.INVENTORY_ITEM_ID || '-' || RG23_1.SLNO FOLIO
735: FROM
736: JAI_CMN_RG_23AC_II_TRXS RG23_2,
737: JAI_CMN_RG_23AC_I_TRXS RG23_1
738: WHERE RG23_2.ORGANIZATION_ID = P_ORGANIZATION_ID
739: AND RG23_2.LOCATION_ID = P_LOCATION_ID
740: AND RG23_2.EXCISE_INVOICE_NO = P_EXCISE_INVOICE_NO
741: AND RG23_2.EXCISE_INVOICE_DATE = P_EXCISE_INVOICE_DATE