eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_OM_RG_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 297: from JAI_CMN_INVENTORY_ORGS

293:
294: /*Bug 5989740 bduvarag end*/
295: cursor c_fetch_cess_account(cp_organization_id number , cp_location_id number) is
296: select cess_paid_payable_account_id
297: from JAI_CMN_INVENTORY_ORGS
298: where organization_id = cp_organization_id
299: and location_id = cp_location_id;
300: /*Bug 5989740 bduvarag start*/
301: cursor c_fetch_sh_cess_account(cp_organization_id number , cp_location_id number) is

Line 303: from JAI_CMN_INVENTORY_ORGS

299: and location_id = cp_location_id;
300: /*Bug 5989740 bduvarag start*/
301: cursor c_fetch_sh_cess_account(cp_organization_id number , cp_location_id number) is
302: select sh_cess_paid_payable_acct_id
303: from JAI_CMN_INVENTORY_ORGS
304: where organization_id = cp_organization_id
305: and location_id = cp_location_id;
306: /*Bug 5989740 bduvarag end*/
307:

Line 320: v_cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;

316: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
317: v_delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type;
318: v_cess_amount number;
319: v_sh_cess_amount number;/*Bug 5989740 bduvarag*/
320: v_cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;
321: v_org_id JAI_OM_WSH_LINES_ALL.org_id%type;
322: ln_sh_Cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;/*Bug 5989740 bduvarag*/
323: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_entries';
324:

Line 322: ln_sh_Cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;/Bug 5989740 bduvarag/

318: v_cess_amount number;
319: v_sh_cess_amount number;/*Bug 5989740 bduvarag*/
320: v_cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;
321: v_org_id JAI_OM_WSH_LINES_ALL.org_id%type;
322: ln_sh_Cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;/*Bug 5989740 bduvarag*/
323: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_entries';
324:
325: /*
326: The procedure assumes that it will be called from the ja_in_accounting_entries procedure only when

Line 916: p_inv_orgn_id JAI_CMN_INVENTORY_ORGS.organization_id%type ,

912: /**********************************************************************************************************************/
913: procedure ja_in_cess_register_entries(
914: p_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%type ,
915: p_register_type varchar2 ,
916: p_inv_orgn_id JAI_CMN_INVENTORY_ORGS.organization_id%type ,
917: p_je_source_name gl_interface.USER_JE_SOURCE_NAME%type ,
918: p_je_category_name gl_interface.USER_JE_CATEGORY_NAME%type ,
919: p_source_type JAI_CMN_RG_OTHERS.source_type%type ,
920: p_currency_code gl_interface.currency_code%type ,

Line 1195: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;

1191: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1192: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1193: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1194: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1195: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1196: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
1197: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
1198: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1199: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;

Line 1198: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;

1194: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1195: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1196: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
1197: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
1198: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1199: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1200: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1201: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_accounting_entries';
1202:

Line 1199: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;

1195: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1196: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
1197: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
1198: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1199: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1200: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1201: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_accounting_entries';
1202:
1203:

Line 1200: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;

1196: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
1197: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
1198: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1199: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1200: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1201: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_accounting_entries';
1202:
1203:
1204: -- get the delivery details

Line 1232: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,

1228: FROM mtl_interorg_parameters
1229: WHERE from_organization_id = p_from_org_id
1230: AND to_organization_id = p_to_org_id;
1231:
1232: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,
1233: cp_location_id JAI_CMN_INVENTORY_ORGS.LOCATION_ID%TYPE
1234: ) IS
1235: SELECT excise_rcvble_account ,
1236: excise_23d_account,

Line 1233: cp_location_id JAI_CMN_INVENTORY_ORGS.LOCATION_ID%TYPE

1229: WHERE from_organization_id = p_from_org_id
1230: AND to_organization_id = p_to_org_id;
1231:
1232: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,
1233: cp_location_id JAI_CMN_INVENTORY_ORGS.LOCATION_ID%TYPE
1234: ) IS
1235: SELECT excise_rcvble_account ,
1236: excise_23d_account,
1237: excise_in_rg23d,

Line 1240: FROM JAI_CMN_INVENTORY_ORGS

1236: excise_23d_account,
1237: excise_in_rg23d,
1238: Trading,
1239: Manufacturing
1240: FROM JAI_CMN_INVENTORY_ORGS
1241: WHERE organization_id = cp_organization_id
1242: AND location_id = cp_location_id;
1243:
1244:

Line 1269: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

1265: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
1266: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1267: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1268: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1269: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1270: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1271: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1272: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1273: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

Line 1270: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

1266: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1267: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1268: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1269: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1270: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1271: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1272: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1273: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1274: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

Line 1271: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

1267: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1268: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1269: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1270: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1271: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1272: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1273: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1274: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1275: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;

Line 1272: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

1268: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1269: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1270: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1271: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1272: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1273: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1274: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1275: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1276: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;

Line 1273: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

1269: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1270: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1271: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1272: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1273: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1274: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1275: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1276: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1277: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;

Line 1274: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

1270: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1271: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1272: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1273: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1274: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
1275: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1276: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
1277: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
1278: ln_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE;

Line 1898: CURSOR c_org_addl_rg_flag (cp_organization_id jai_cmn_inventory_orgs.organization_id%type,

1894:
1895: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg_I_entry';
1896:
1897: /*bug 9122545*/
1898: CURSOR c_org_addl_rg_flag (cp_organization_id jai_cmn_inventory_orgs.organization_id%type,
1899: cp_location_id jai_cmn_inventory_orgs.location_id%type)
1900: IS
1901: SELECT nvl(allow_negative_rg_flag,'N')
1902: FROM jai_cmn_inventory_orgs

Line 1899: cp_location_id jai_cmn_inventory_orgs.location_id%type)

1895: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg_I_entry';
1896:
1897: /*bug 9122545*/
1898: CURSOR c_org_addl_rg_flag (cp_organization_id jai_cmn_inventory_orgs.organization_id%type,
1899: cp_location_id jai_cmn_inventory_orgs.location_id%type)
1900: IS
1901: SELECT nvl(allow_negative_rg_flag,'N')
1902: FROM jai_cmn_inventory_orgs
1903: WHERE organization_id = cp_organization_id

Line 1902: FROM jai_cmn_inventory_orgs

1898: CURSOR c_org_addl_rg_flag (cp_organization_id jai_cmn_inventory_orgs.organization_id%type,
1899: cp_location_id jai_cmn_inventory_orgs.location_id%type)
1900: IS
1901: SELECT nvl(allow_negative_rg_flag,'N')
1902: FROM jai_cmn_inventory_orgs
1903: WHERE organization_id = cp_organization_id
1904: AND location_id = cp_location_id;
1905:
1906: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%type;

Line 1906: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%type;

1902: FROM jai_cmn_inventory_orgs
1903: WHERE organization_id = cp_organization_id
1904: AND location_id = cp_location_id;
1905:
1906: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%type;
1907: /*end bug 9122545*/
1908:
1909: /*------------------------------------------------------------------------------------------
1910: FILENAME: jai_om_rg_pkg.sql

Line 2626: FROM JAI_CMN_INVENTORY_ORGS

2622: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
2623: WHERE A.site_use_id = p_customer_site_id);
2624: CURSOR rm_account_cur IS
2625: SELECT modvat_rm_account_id , excise_edu_cess_rm_account ,SH_CESS_RM_ACCOUNT/*Bug 5989740 bduvarag*/
2626: FROM JAI_CMN_INVENTORY_ORGS
2627: WHERE organization_id = p_org_id AND location_id = p_location_id;
2628:
2629: CURSOR cg_account_cur IS
2630: SELECT modvat_cg_account_id , excise_edu_cess_cg_account ,SH_CESS_CG_ACCOUNT_ID/*Bug 5989740 bduvarag*/

Line 2631: FROM JAI_CMN_INVENTORY_ORGS

2627: WHERE organization_id = p_org_id AND location_id = p_location_id;
2628:
2629: CURSOR cg_account_cur IS
2630: SELECT modvat_cg_account_id , excise_edu_cess_cg_account ,SH_CESS_CG_ACCOUNT_ID/*Bug 5989740 bduvarag*/
2631: FROM JAI_CMN_INVENTORY_ORGS
2632: WHERE organization_id = p_org_id AND location_id = p_location_id;
2633:
2634: CURSOR debit_account_cur IS
2635: SELECT EXCISE_RCVBLE_ACCOUNT , CESS_PAID_PAYABLE_ACCOUNT_ID , /* CESS_PAID_PAYABLE_ACCOUNT_ID added by ssumaith */

Line 2637: FROM JAI_CMN_INVENTORY_ORGS

2633:
2634: CURSOR debit_account_cur IS
2635: SELECT EXCISE_RCVBLE_ACCOUNT , CESS_PAID_PAYABLE_ACCOUNT_ID , /* CESS_PAID_PAYABLE_ACCOUNT_ID added by ssumaith */
2636: SH_CESS_PAID_PAYABLE_ACCT_ID/*Bug 5989740 bduvarag*/
2637: FROM JAI_CMN_INVENTORY_ORGS
2638: WHERE organization_id = p_org_id AND location_id = p_location_id;
2639:
2640: CURSOR mod_debit_acc_org IS
2641: SELECT MODVAT_REVERSE_ACCOUNT_ID

Line 2642: FROM JAI_CMN_INVENTORY_ORGS

2638: WHERE organization_id = p_org_id AND location_id = p_location_id;
2639:
2640: CURSOR mod_debit_acc_org IS
2641: SELECT MODVAT_REVERSE_ACCOUNT_ID
2642: FROM JAI_CMN_INVENTORY_ORGS
2643: WHERE organization_id = p_org_id
2644: AND location_id = p_location_id;
2645:
2646: /* Bug 4931887. Added by Lakshmi Gopalsami

Line 2655: FROM JAI_CMN_INVENTORY_ORGS

2651:
2652:
2653: CURSOR ssi_unit_flag_cur IS
2654: SELECT ssi_unit_flag
2655: FROM JAI_CMN_INVENTORY_ORGS
2656: WHERE organization_id = p_org_id AND
2657: location_id = p_location_id;
2658:
2659:

Line 3068: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%TYPE;

3064: v_additional_opening_balance NUMBER;
3065: v_additional_closing_balance NUMBER;
3066: v_other_opening_balance NUMBER;
3067: v_other_closing_balance NUMBER;
3068: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%TYPE;
3069: v_rg_basic_balance NUMBER;
3070: v_rg_additional_balance NUMBER;
3071: v_rg_other_balance NUMBER;
3072: v_order_type_id JAI_OM_WSH_LINES_ALL.order_type_id%TYPE;

Line 3115: FROM JAI_CMN_INVENTORY_ORGS

3111:
3112: --Changed by Nagaraj.s for Enh2415656...
3113: CURSOR pla_account_cur IS
3114: SELECT MODVAT_PLA_ACCOUNT_ID,NVL(export_oriented_unit,'N')
3115: FROM JAI_CMN_INVENTORY_ORGS
3116: WHERE organization_id = p_org_id
3117: AND location_id = p_location_id;
3118:
3119: CURSOR debit_account_cur IS

Line 3122: FROM JAI_CMN_INVENTORY_ORGS

3118:
3119: CURSOR debit_account_cur IS
3120: SELECT EXCISE_RCVBLE_ACCOUNT , CESS_PAID_PAYABLE_ACCOUNT_ID, /* CESS_PAID_PAYABLE_ACCOUNT_ID added by ssumaith */
3121: SH_CESS_PAID_PAYABLE_ACCT_ID/*Bug 5989740 bduvarag*/
3122: FROM JAI_CMN_INVENTORY_ORGS
3123: WHERE organization_id = p_org_id AND location_id = p_location_id;
3124:
3125: /* Bug 4931887. Added by Lakshmi Gopalsami
3126: Removed the references to currency_cur

Line 3133: FROM JAI_CMN_INVENTORY_ORGS

3129: */
3130:
3131: CURSOR ssi_unit_flag_cur IS
3132: SELECT NVL(ssi_unit_flag, 'N')
3133: FROM JAI_CMN_INVENTORY_ORGS
3134: WHERE organization_id = p_org_id AND
3135: location_id = p_location_id;
3136:
3137: --Cursors Added by Nagaraj.s for ENH2415656..

Line 3769: FROM JAI_CMN_INVENTORY_ORGS

3765: -- End, Vijay Shankar for Bug# 3657742
3766: /*
3767: CURSOR rg23d_Account IS
3768: SELECT EXCISE_23D_ACCOUNT
3769: FROM JAI_CMN_INVENTORY_ORGS
3770: WHERE organization_id = p_org_id AND location_id = p_location_id;
3771:
3772: CURSOR debit_account_cur IS
3773: SELECT EXCISE_RCVBLE_ACCOUNT , CESS_PAID_PAYABLE_ACCOUNT_ID

Line 3774: FROM JAI_CMN_INVENTORY_ORGS

3770: WHERE organization_id = p_org_id AND location_id = p_location_id;
3771:
3772: CURSOR debit_account_cur IS
3773: SELECT EXCISE_RCVBLE_ACCOUNT , CESS_PAID_PAYABLE_ACCOUNT_ID
3774: FROM JAI_CMN_INVENTORY_ORGS
3775: WHERE organization_id = p_org_id AND location_id = p_location_id;
3776: */
3777: /* Bug 4931887. Added by Lakshmi Gopalsami
3778: Removed the references to currency_cur

Line 3814: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,

3810: FROM mtl_interorg_parameters
3811: WHERE from_organization_id = p_from_org_id
3812: AND to_organization_id = p_to_org_id;
3813:
3814: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,
3815: cp_location_id JAI_CMN_INVENTORY_ORGS.LOCATION_ID%TYPE
3816: ) IS
3817: SELECT excise_rcvble_account , excise_23d_account ,excise_in_rg23d , Trading, manufacturing
3818: ,cess_paid_payable_account_id, sh_cess_paid_payable_acct_id /*Added two columns by mmurtuza for bug 16022303*/

Line 3815: cp_location_id JAI_CMN_INVENTORY_ORGS.LOCATION_ID%TYPE

3811: WHERE from_organization_id = p_from_org_id
3812: AND to_organization_id = p_to_org_id;
3813:
3814: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,
3815: cp_location_id JAI_CMN_INVENTORY_ORGS.LOCATION_ID%TYPE
3816: ) IS
3817: SELECT excise_rcvble_account , excise_23d_account ,excise_in_rg23d , Trading, manufacturing
3818: ,cess_paid_payable_account_id, sh_cess_paid_payable_acct_id /*Added two columns by mmurtuza for bug 16022303*/
3819: FROM JAI_CMN_INVENTORY_ORGS

Line 3819: FROM JAI_CMN_INVENTORY_ORGS

3815: cp_location_id JAI_CMN_INVENTORY_ORGS.LOCATION_ID%TYPE
3816: ) IS
3817: SELECT excise_rcvble_account , excise_23d_account ,excise_in_rg23d , Trading, manufacturing
3818: ,cess_paid_payable_account_id, sh_cess_paid_payable_acct_id /*Added two columns by mmurtuza for bug 16022303*/
3819: FROM JAI_CMN_INVENTORY_ORGS
3820: WHERE organization_id = cp_organization_id
3821: AND location_id = cp_location_id;
3822:
3823:

Line 3849: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

3845: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
3846: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3847: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3848: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3849: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3850: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3851: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3852: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3853: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

Line 3850: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

3846: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3847: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3848: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3849: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3850: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3851: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3852: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3853: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3854: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

Line 3851: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

3847: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3848: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3849: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3850: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3851: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3852: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3853: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3854: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3855: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;

Line 3852: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

3848: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3849: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3850: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3851: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3852: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3853: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3854: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3855: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3856: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;

Line 3853: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

3849: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3850: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3851: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3852: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3853: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3854: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3855: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3856: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3857: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;

Line 3854: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

3850: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3851: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3852: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3853: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3854: lv_dest_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;
3855: ln_debit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3856: ln_credit_acc GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3857: ln_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
3858: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;/*Bug 5989740 bduvarag*/

Line 3870: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;

3866: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3867: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3868: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3869: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3870: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3871: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
3872: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3873: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3874: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;

Line 3873: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;

3869: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3870: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3871: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
3872: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3873: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3874: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3875: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3876:
3877: /*Start additons by mmurtuza for bug 16022303*/

Line 3874: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;

3870: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3871: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
3872: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3873: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3874: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3875: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3876:
3877: /*Start additons by mmurtuza for bug 16022303*/
3878: ln_credit_acc_cess_paid GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;

Line 3875: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;

3871: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
3872: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3873: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3874: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3875: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3876:
3877: /*Start additons by mmurtuza for bug 16022303*/
3878: ln_credit_acc_cess_paid GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3879: ln_credit_acc_sh_cess_paid GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;

Line 3880: ln_dest_credit_acc_cess_paid JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%TYPE;

3876:
3877: /*Start additons by mmurtuza for bug 16022303*/
3878: ln_credit_acc_cess_paid GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3879: ln_credit_acc_sh_cess_paid GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3880: ln_dest_credit_acc_cess_paid JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%TYPE;
3881: ln_dest_credit_acc_shcess_paid JAI_CMN_INVENTORY_ORGS.sh_cess_paid_payable_acct_id%TYPE;
3882: /*End additons by mmurtuza for bug 16022303*/
3883:
3884: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23d_entry';

Line 3881: ln_dest_credit_acc_shcess_paid JAI_CMN_INVENTORY_ORGS.sh_cess_paid_payable_acct_id%TYPE;

3877: /*Start additons by mmurtuza for bug 16022303*/
3878: ln_credit_acc_cess_paid GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3879: ln_credit_acc_sh_cess_paid GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
3880: ln_dest_credit_acc_cess_paid JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%TYPE;
3881: ln_dest_credit_acc_shcess_paid JAI_CMN_INVENTORY_ORGS.sh_cess_paid_payable_acct_id%TYPE;
3882: /*End additons by mmurtuza for bug 16022303*/
3883:
3884: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23d_entry';
3885: