APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 227: from JAI_CMN_INVENTORY_ORGS

223:
224: --added the cursor for bug#6327274
225: cursor c_orgn_Null_site_info is
226: select exc_shpt_wo_exc_tax_flag
227: from JAI_CMN_INVENTORY_ORGS
228: where organization_id = pr_new.organization_id
229: and location_id = 0;
230:
231:

Line 420: from JAI_CMN_INVENTORY_ORGS

416:
417: -- added by sriram - bug#3441684
418: cursor c_orgn_info is
419: select trading
420: from JAI_CMN_INVENTORY_ORGS
421: where organization_id = pr_new.organization_id
422: and location_id = pr_new.ship_from_location_id ;
423: --ends here additions by sriram - bug#3441684
424:

Line 1354: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%TYPE;

1350: v_exe_flag VARCHAR2(150);
1351: v_mod_flag VARCHAR2(150);
1352: --New Variables Declared by Nagaraj.s for Enh2415656
1353: v_output NUMBER ;-- By Nagaraj.s to get the output of the function jai_om_wsh_processing_pkg.excise_balance_check
1354: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%TYPE;
1355: v_basic_pla_balance NUMBER;
1356: v_additional_pla_balance NUMBER;
1357: v_other_pla_balance NUMBER;
1358: v_error_message NUMBER; --This is for Capturing the Error Message

Line 1640: FROM JAI_CMN_INVENTORY_ORGS

1636: CURSOR pref_cur(p_organization_id NUMBER, p_location_id NUMBER)IS
1637: --This is included in the select by Nagaraj.s for Enh2415656
1638: SELECT pref_rg23a, pref_rg23c, pref_pla,
1639: NVL(Export_oriented_unit ,'N')
1640: FROM JAI_CMN_INVENTORY_ORGS
1641: WHERE organization_id = p_organization_id
1642: AND location_id = p_location_id ;
1643: --This is included in the select by Nagaraj.s for Enh2415656
1644: CURSOR rg_bal_cur(p_organization_id NUMBER, p_location_id NUMBER)IS

Line 1654: FROM JAI_CMN_INVENTORY_ORGS

1650: WHERE organization_id = p_organization_id
1651: AND location_id = p_location_id ;
1652: CURSOR ssi_unit_flag_cur(p_organization_id NUMBER, p_location_id NUMBER) IS
1653: SELECT ssi_unit_flag
1654: FROM JAI_CMN_INVENTORY_ORGS
1655: WHERE organization_id = p_organization_id
1656: AND location_id = p_location_id;
1657: CURSOR register_balance_cur(p_organization_id NUMBER,p_location_id NUMBER) IS
1658: SELECT register_balance

Line 1674: FROM JAI_CMN_INVENTORY_ORGS

1670: AND b.tax_type = 'Modvat Recovery'
1671: ORDER BY A.Tax_Line_No;
1672: CURSOR for_modvat_percentage(p_organization_id NUMBER, p_location_id NUMBER) IS
1673: SELECT MODVAT_REVERSE_PERCENT
1674: FROM JAI_CMN_INVENTORY_ORGS
1675: WHERE organization_id = p_organization_id
1676: AND ( location_id = p_location_id
1677: OR
1678: location_id is NULL AND p_location_id is NULL); /* Modified by Ramananda for removal of SQL LITERALs */

Line 3650: FROM JAI_CMN_INVENTORY_ORGS

3646:
3647: CURSOR c_get_il_setup IS
3648: SELECT trading, excise_rcvble_account, excise_paid_account, excise_23d_account, excise_in_rg23d, order_price_excise_inclusive,
3649: cess_paid_payable_account_id, sh_cess_paid_payable_acct_id
3650: FROM JAI_CMN_INVENTORY_ORGS
3651: WHERE organization_id = pr_trig_row.organization_id
3652: AND location_id = pr_trig_row.ship_from_location_id;
3653:
3654: CURSOR c_get_cost_of_goods_ac IS