[Home] [Help]
63: only for trading organization or Manufacturing org for a Bonded subinventory.
64:
65: 13. 12/10/2007 rchandan for bug#6497301,6487489. File version 120.12
66: Issue : R12RUP04.I/ORG.QA.ST1: NOT ABLE TO MAKE A CAPTIAL GOODS TRANSFER FOR INTRANSIT
67: Fix : It is identified that there are new columns added to table jai_rcv_journal_entries
68: and these are not null. As the impact of this is not taken care in cenvat_auto_claim
69: procedure this issue was coming.
70: Now added these columns in the insert into JAI_RCV_JOURNAL_ENTRIES
71: Issue : R12RUP04.I/ORG.QA.ST1: PPV ENTRY TO BE GENERATED FOR STD COST REC ORG
66: Issue : R12RUP04.I/ORG.QA.ST1: NOT ABLE TO MAKE A CAPTIAL GOODS TRANSFER FOR INTRANSIT
67: Fix : It is identified that there are new columns added to table jai_rcv_journal_entries
68: and these are not null. As the impact of this is not taken care in cenvat_auto_claim
69: procedure this issue was coming.
70: Now added these columns in the insert into JAI_RCV_JOURNAL_ENTRIES
71: Issue : R12RUP04.I/ORG.QA.ST1: PPV ENTRY TO BE GENERATED FOR STD COST REC ORG
72: Fix : For standard costing , Purchase price variance entry needs to generated
73: for the non - recoverable tax amount.
74: Made changes in std_cost_entry procedure to this effect.
3914: );
3915:
3916: lv_Reference_10 := 'India Local Receiving Entry for the Receipt Number' || r_trx.receipt_num || 'for the Trx Type RECEIVE for the Organization code' || r_mtl_params.organization_code ;
3917: --cr cenvat receivable accnt ,10607819
3918: insert into JAI_RCV_JOURNAL_ENTRIES
3919: (
3920: JOURNAL_ENTRY_ID,
3921: ORGANIZATION_CODE,
3922: RECEIPT_NUM,
3945: last_update_login /*6497301*/
3946:
3947: )
3948: VALUES
3949: (jai_rcv_journal_entries_s.nextval,/*6497301*/
3950: r_mtl_params.organization_code ,
3951: r_trx.receipt_num ,
3952: r_trx.transaction_id ,
3953: sysdate ,
4031: r_trx.organization_id
4032: );
4033:
4034: --dr modvat cg accnt 10607819
4035: INSERT INTO JAI_RCV_JOURNAL_ENTRIES
4036: (
4037: JOURNAL_ENTRY_ID ,
4038: ORGANIZATION_CODE ,
4039: RECEIPT_NUM ,
4061: last_updated_by ,/*6497301*/
4062: last_update_login /*6497301*/
4063: )
4064: VALUES
4065: (jai_rcv_journal_entries_s.nextval,
4066: r_mtl_params.organization_code ,
4067: r_trx.receipt_num ,
4068: r_trx.transaction_id ,
4069: sysdate ,
4209: --end additions for bug#10607819
4210:
4211: IF ln_Cess_amt IS NOT NULL THEN
4212: --cr edu cess receivable accnt
4213: INSERT INTO JAI_RCV_JOURNAL_ENTRIES
4214: (
4215: JOURNAL_ENTRY_ID,
4216: ORGANIZATION_CODE ,
4217: RECEIPT_NUM ,
4239: last_updated_by ,/*6497301*/
4240: last_update_login /*6497301*/
4241: )
4242: VALUES
4243: (jai_rcv_journal_entries_s.nextval,/*6497301*/
4244: r_mtl_params.organization_code ,
4245: r_trx.receipt_num ,
4246: r_trx.transaction_id ,
4247: sysdate ,
4323: r_trx.organization_id
4324: );
4325:
4326: --dr edu cess CG account 10607819
4327: INSERT INTO JAI_RCV_JOURNAL_ENTRIES
4328: (
4329: JOURNAL_ENTRY_ID,
4330: ORGANIZATION_CODE ,
4331: RECEIPT_NUM ,
4354: last_update_login /*6497301*/
4355: )
4356: VALUES
4357: (
4358: jai_rcv_journal_entries_s.nextval,/*6497301*/
4359: r_mtl_params.organization_code ,
4360: r_trx.receipt_num,
4361: r_trx.transaction_id ,
4362: sysdate ,
4440: END IF;
4441: --start additions for bug#10607819
4442: IF ln_shCess_amt IS NOT NULL THEN
4443: --cr excise rcvble accnt 10607819
4444: INSERT INTO JAI_RCV_JOURNAL_ENTRIES
4445: (
4446: JOURNAL_ENTRY_ID,
4447: ORGANIZATION_CODE ,
4448: RECEIPT_NUM ,
4470: last_updated_by ,/*6497301*/
4471: last_update_login /*6497301*/
4472: )
4473: VALUES
4474: (jai_rcv_journal_entries_s.nextval,/*6497301*/
4475: r_mtl_params.organization_code ,
4476: r_trx.receipt_num ,
4477: r_trx.transaction_id ,
4478: sysdate ,
4554: r_trx.organization_id
4555: );
4556:
4557: --dr cg accnt 10607819
4558: INSERT INTO JAI_RCV_JOURNAL_ENTRIES
4559: (
4560: JOURNAL_ENTRY_ID,
4561: ORGANIZATION_CODE ,
4562: RECEIPT_NUM ,
4585: last_update_login /*6497301*/
4586: )
4587: VALUES
4588: (
4589: jai_rcv_journal_entries_s.nextval,/*6497301*/
4590: r_mtl_params.organization_code ,
4591: r_trx.receipt_num,
4592: r_trx.transaction_id ,
4593: sysdate ,