579: A.TRANSACTION_DATE,
580: A.LAST_UPDATE_LOGIN
581: FROM JAI_CMN_RG_PLA_TRXS A
582: WHERE NOT EXISTS ( SELECT '1'
583: FROM JAI_CMN_RG_PLA_CMP_DTLS B
584: WHERE B.REGISTER_ID = A.REGISTER_ID
585: AND B.SLNO = A.SLNO)
586: ORDER BY REGISTER_ID,SLNO;
587:
608: This Procedure is Created for Textile Industry specifically wherin individual
609: balances of Excise components are to be maintained.
610: In case of data not existing in Excise Component Balances for an combination of
611: Organization/Location, this will inserts data into JAI_CMN_RG_COMP_BALS
612: and JAI_CMN_RG_PLA_CMP_DTLS tables and if data exists, then it will insert data
613: into JAI_CMN_RG_PLA_CMP_DTLS and updates JAI_CMN_RG_COMP_BALS table.
614:
615: -----------------------------------------------------------------------------------------------
616: */
609: balances of Excise components are to be maintained.
610: In case of data not existing in Excise Component Balances for an combination of
611: Organization/Location, this will inserts data into JAI_CMN_RG_COMP_BALS
612: and JAI_CMN_RG_PLA_CMP_DTLS tables and if data exists, then it will insert data
613: into JAI_CMN_RG_PLA_CMP_DTLS and updates JAI_CMN_RG_COMP_BALS table.
614:
615: -----------------------------------------------------------------------------------------------
616: */
617:
685: V_OTHER_CLOSING_BALANCE := V_OTHER_OPENING_BALANCE + NVL(CUR_REC.CR_OTHER_ED,0) - NVL(CUR_REC.DR_OTHER_ED,0);
686: END;
687:
688:
689: INSERT INTO JAI_CMN_RG_PLA_CMP_DTLS
690: (
691: ORGANIZATION_ID,
692: LOCATION_ID,
693: INVENTORY_ITEM_ID,