APPS.JAI_MTL_TRXS_PKG dependencies on JAI_RCV_JOURNAL_ENTRIES

Line 67: Fix : It is identified that there are new columns added to table jai_rcv_journal_entries

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

Line 70: Now added these columns in the insert into JAI_RCV_JOURNAL_ENTRIES

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.

Line 3743: insert into JAI_RCV_JOURNAL_ENTRIES

3739: );
3740:
3741: 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 ;
3742:
3743: insert into JAI_RCV_JOURNAL_ENTRIES
3744: (
3745: JOURNAL_ENTRY_ID,
3746: ORGANIZATION_CODE,
3747: RECEIPT_NUM,

Line 3774: (jai_rcv_journal_entries_s.nextval,/*6497301*/

3770: last_update_login /*6497301*/
3771:
3772: )
3773: VALUES
3774: (jai_rcv_journal_entries_s.nextval,/*6497301*/
3775: r_mtl_params.organization_code ,
3776: r_trx.receipt_num ,
3777: r_trx.transaction_id ,
3778: sysdate ,

Line 3858: INSERT INTO JAI_RCV_JOURNAL_ENTRIES

3854: r_trx.organization_id
3855: );
3856:
3857:
3858: INSERT INTO JAI_RCV_JOURNAL_ENTRIES
3859: (
3860: JOURNAL_ENTRY_ID ,
3861: ORGANIZATION_CODE ,
3862: RECEIPT_NUM ,

Line 3888: (jai_rcv_journal_entries_s.nextval,

3884: last_updated_by ,/*6497301*/
3885: last_update_login /*6497301*/
3886: )
3887: VALUES
3888: (jai_rcv_journal_entries_s.nextval,
3889: r_mtl_params.organization_code ,
3890: r_trx.receipt_num ,
3891: r_trx.transaction_id ,
3892: sysdate ,

Line 4005: INSERT INTO JAI_RCV_JOURNAL_ENTRIES

4001: END IF;
4002:
4003: IF ln_Cess_amt IS NOT NULL THEN
4004:
4005: INSERT INTO JAI_RCV_JOURNAL_ENTRIES
4006: (
4007: JOURNAL_ENTRY_ID,
4008: ORGANIZATION_CODE ,
4009: RECEIPT_NUM ,

Line 4035: (jai_rcv_journal_entries_s.nextval,/*6497301*/

4031: last_updated_by ,/*6497301*/
4032: last_update_login /*6497301*/
4033: )
4034: VALUES
4035: (jai_rcv_journal_entries_s.nextval,/*6497301*/
4036: r_mtl_params.organization_code ,
4037: r_trx.receipt_num ,
4038: r_trx.transaction_id ,
4039: sysdate ,

Line 4119: INSERT INTO JAI_RCV_JOURNAL_ENTRIES

4115: r_trx.organization_id
4116: );
4117:
4118:
4119: INSERT INTO JAI_RCV_JOURNAL_ENTRIES
4120: (
4121: JOURNAL_ENTRY_ID,
4122: ORGANIZATION_CODE ,
4123: RECEIPT_NUM ,

Line 4150: jai_rcv_journal_entries_s.nextval,/*6497301*/

4146: last_update_login /*6497301*/
4147: )
4148: VALUES
4149: (
4150: jai_rcv_journal_entries_s.nextval,/*6497301*/
4151: r_mtl_params.organization_code ,
4152: r_trx.receipt_num,
4153: r_trx.transaction_id ,
4154: sysdate ,