APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 163: FROM JAI_CMN_INVENTORY_ORGS

159:
160:
161: cursor c_get_org_info IS
162: SELECT excise_in_RG23D excise_in_trading , NVL(manufacturing,'N') , NVL(trading ,'N')
163: FROM JAI_CMN_INVENTORY_ORGS
164: WHERE organization_id = p_organization_id
165: AND location_id = p_location_id;
166:
167: cursor c_get_item_info IS

Line 355: FROM JAI_CMN_INVENTORY_ORGS

351: /*Commented by nprashar for bug # 6710747 AND trx.excise_invoice_no IS NOT NULL;*/
352:
353: CURSOR organization_type_cur(p_org_id number,p_loc_id number) IS
354: SELECT trading, manufacturing, excise_duty_range, excise_duty_division
355: FROM JAI_CMN_INVENTORY_ORGS
356: WHERE organization_id = p_org_id
357: AND location_id = p_loc_id;
358:
359:

Line 389: l_trading JAI_CMN_INVENTORY_ORGS.trading%TYPE;

385:
386:
387: r_rcpts_match c_rcpts_match%rowtype;
388:
389: l_trading JAI_CMN_INVENTORY_ORGS.trading%TYPE;
390: l_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%TYPE;
391: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
392: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
393: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;

Line 390: l_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%TYPE;

386:
387: r_rcpts_match c_rcpts_match%rowtype;
388:
389: l_trading JAI_CMN_INVENTORY_ORGS.trading%TYPE;
390: l_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%TYPE;
391: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
392: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
393: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
394: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;

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

1160: 'A',
1161: null,
1162: p_params(i).amount,
1163: sysdate,
1164: p_params(i).debit_account, -- Derived Value from JAI_CMN_INVENTORY_ORGS / mtl_interorg_parameters
1165: null,
1166: null,
1167: null,
1168: p_params(i).organization_code, -- From mtl_parameters

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

1220: fnd_global.user_id,
1221: null,
1222: p_params(i).amount,
1223: sysdate,
1224: p_params(i).debit_account, -- Derived Value from JAI_CMN_INVENTORY_ORGS / mtl_interorg_parameters
1225: null,
1226: null,
1227: null,
1228: p_params(i).organization_code, -- From mtl_parameters

Line 1425: r_from_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;

1421: rec NUMBER := 0;
1422: /*
1423: ccids from organization additional information setup
1424: */
1425: r_from_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;
1426: r_to_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;
1427:
1428: /*
1429: ccids from mtl interorg parameters

Line 1426: r_to_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;

1422: /*
1423: ccids from organization additional information setup
1424: */
1425: r_from_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;
1426: r_to_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;
1427:
1428: /*
1429: ccids from mtl interorg parameters
1430: */

Line 1449: FROM JAI_CMN_INVENTORY_ORGS

1445: AND sub_inventory_name = p_subinventory;
1446:
1447: CURSOR c_get_ja_accts(p_organization_id NUMBER , p_location_id number) IS
1448: SELECT *
1449: FROM JAI_CMN_INVENTORY_ORGS
1450: WHERE organization_id = p_organization_id
1451: AND location_id = p_location_id;
1452:
1453: CURSOR c_get_interorg_params( p_from_organization_id IN NUMBER, p_to_organization_id IN NUMBER ) IS

Line 3586: FROM JAI_CMN_INVENTORY_ORGS

3582: WHERE organization_id = cp_organization_id;
3583:
3584: CURSOR c_cenvat_accts (cp_organization_id IN NUMBER , cp_location_id IN NUMBER) IS
3585: select *
3586: FROM JAI_CMN_INVENTORY_ORGS
3587: WHERE organization_id = cp_organization_id
3588: AND location_id = cp_location_id ;
3589:
3590: CURSOR c_gl_periods(cp_set_of_books_id IN NUMBER) IS