APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 286: FROM JAI_CMN_INVENTORY_ORGS

282:
283:
284: cursor c_get_org_info IS
285: SELECT excise_in_RG23D excise_in_trading , NVL(manufacturing,'N') , NVL(trading ,'N')
286: FROM JAI_CMN_INVENTORY_ORGS
287: WHERE organization_id = p_organization_id
288: AND location_id = p_location_id;
289:
290: cursor c_get_item_info IS

Line 478: FROM JAI_CMN_INVENTORY_ORGS

474: /*Commented by nprashar for bug # 6710747 AND trx.excise_invoice_no IS NOT NULL;*/
475:
476: CURSOR organization_type_cur(p_org_id number,p_loc_id number) IS
477: SELECT trading, manufacturing, excise_duty_range, excise_duty_division
478: FROM JAI_CMN_INVENTORY_ORGS
479: WHERE organization_id = p_org_id
480: AND location_id = p_loc_id;
481:
482:

Line 512: l_trading JAI_CMN_INVENTORY_ORGS.trading%TYPE;

508:
509:
510: r_rcpts_match c_rcpts_match%rowtype;
511:
512: l_trading JAI_CMN_INVENTORY_ORGS.trading%TYPE;
513: l_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%TYPE;
514: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
515: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
516: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;

Line 513: l_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%TYPE;

509:
510: r_rcpts_match c_rcpts_match%rowtype;
511:
512: l_trading JAI_CMN_INVENTORY_ORGS.trading%TYPE;
513: l_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%TYPE;
514: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
515: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
516: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
517: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;

Line 1292: p_params(i).debit_account, -- Derived Value from JAI_CMN_INVENTORY_ORGS / mtl_interorg_parameters

1288: 'A',
1289: null,
1290: p_params(i).amount,
1291: sysdate,
1292: p_params(i).debit_account, -- Derived Value from JAI_CMN_INVENTORY_ORGS / mtl_interorg_parameters
1293: null,
1294: null,
1295: null,
1296: p_params(i).organization_code, -- From mtl_parameters

Line 1352: p_params(i).debit_account, -- Derived Value from JAI_CMN_INVENTORY_ORGS / mtl_interorg_parameters

1348: fnd_global.user_id,
1349: null,
1350: p_params(i).amount,
1351: sysdate,
1352: p_params(i).debit_account, -- Derived Value from JAI_CMN_INVENTORY_ORGS / mtl_interorg_parameters
1353: null,
1354: null,
1355: null,
1356: p_params(i).organization_code, -- From mtl_parameters

Line 1553: r_from_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;

1549: rec NUMBER := 0;
1550: /*
1551: ccids from organization additional information setup
1552: */
1553: r_from_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;
1554: r_to_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;
1555:
1556: /*
1557: ccids from mtl interorg parameters

Line 1554: r_to_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;

1550: /*
1551: ccids from organization additional information setup
1552: */
1553: r_from_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;
1554: r_to_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;
1555:
1556: /*
1557: ccids from mtl interorg parameters
1558: */

Line 1577: FROM JAI_CMN_INVENTORY_ORGS

1573: AND sub_inventory_name = p_subinventory;
1574:
1575: CURSOR c_get_ja_accts(p_organization_id NUMBER , p_location_id number) IS
1576: SELECT *
1577: FROM JAI_CMN_INVENTORY_ORGS
1578: WHERE organization_id = p_organization_id
1579: AND location_id = p_location_id;
1580:
1581: CURSOR c_get_interorg_params( p_from_organization_id IN NUMBER, p_to_organization_id IN NUMBER ) IS

Line 3750: FROM JAI_CMN_INVENTORY_ORGS

3746: WHERE organization_id = cp_organization_id;
3747:
3748: CURSOR c_cenvat_accts (cp_organization_id IN NUMBER , cp_location_id IN NUMBER) IS
3749: select *
3750: FROM JAI_CMN_INVENTORY_ORGS
3751: WHERE organization_id = cp_organization_id
3752: AND location_id = cp_location_id ;
3753:
3754: CURSOR c_gl_periods(cp_set_of_books_id IN NUMBER) IS