APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 195: from JAI_CMN_INVENTORY_ORGS

191: v_quantity number;
192:
193: cursor c_orgn_info is
194: select trading
195: from JAI_CMN_INVENTORY_ORGS
196: where organization_id = pr_new.organization_id
197: and location_id = pr_new.ship_from_location_id ;
198:
199: lv_process_flag VARCHAR2 (2);

Line 498: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%TYPE;

494: v_basic_ed_amt NUMBER;
495: v_register_balance NUMBER;
496: v_exe_flag VARCHAR2(150);
497: v_mod_flag VARCHAR2(150);
498: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%TYPE;
499: v_basic_pla_balance NUMBER;
500: v_additional_pla_balance NUMBER;
501: v_other_pla_balance NUMBER;
502: ln_vat_assessable_value JAI_OM_OE_SO_LINES.VAT_ASSESSABLE_VALUE%TYPE;

Line 731: FROM JAI_CMN_INVENTORY_ORGS

727: SELECT pref_rg23a,
728: pref_rg23c,
729: pref_pla,
730: NVL(Export_oriented_unit ,'N')
731: FROM JAI_CMN_INVENTORY_ORGS
732: WHERE organization_id = p_organization_id
733: AND location_id = p_location_id ;
734:
735: CURSOR rg_bal_cur(p_organization_id NUMBER, p_location_id NUMBER)IS

Line 748: FROM JAI_CMN_INVENTORY_ORGS

744: AND location_id = p_location_id ;
745:
746: CURSOR ssi_unit_flag_cur(p_organization_id NUMBER, p_location_id NUMBER) IS
747: SELECT ssi_unit_flag
748: FROM JAI_CMN_INVENTORY_ORGS
749: WHERE organization_id = p_organization_id
750: AND location_id = p_location_id;
751:
752: CURSOR Get_Tax_Lines_Details_Cur1 IS

Line 762: FROM JAI_CMN_INVENTORY_ORGS

758: ORDER BY A.Tax_Line_No;
759:
760: CURSOR for_modvat_percentage(p_organization_id NUMBER, p_location_id NUMBER) IS
761: SELECT MODVAT_REVERSE_PERCENT
762: FROM JAI_CMN_INVENTORY_ORGS
763: WHERE organization_id = p_organization_id
764: AND ( location_id = p_location_id OR
765: location_id is NULL AND p_location_id is NULL);
766:

Line 2021: FROM JAI_CMN_INVENTORY_ORGS

2017: excise_in_rg23d,
2018: order_price_excise_inclusive,
2019: cess_paid_payable_account_id,
2020: sh_cess_paid_payable_acct_id
2021: FROM JAI_CMN_INVENTORY_ORGS
2022: WHERE organization_id = pr_trig_row.organization_id
2023: AND location_id = pr_trig_row.ship_from_location_id;
2024:
2025: CURSOR c_get_cost_of_goods_ac IS