APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on JAI_INV_ITM_SETUPS

Line 66: JAI_INV_ITM_SETUPS

62: IS
63: SELECT
64: Item_Trading_Flag
65: FROM
66: JAI_INV_ITM_SETUPS
67: WHERE
68: organization_id = v_organization_id AND
69: inventory_item_id = v_inventory_item_id;
70:

Line 105: JAI_INV_ITM_SETUPS jmsi

101: nvl(container_item_flag,'N'),
102: nvl(inventory_item_flag,'N')
103: FROM
104: mtl_system_items msi,
105: JAI_INV_ITM_SETUPS jmsi
106: WHERE msi.organization_id = jmsi.organization_id
107: AND msi.inventory_item_id = jmsi.inventory_item_id
108: AND jmsi.inventory_item_id = v_Inventory_Item_Id
109: AND jmsi.organization_id = v_organization_id;

Line 490: v_item_class JAI_INV_ITM_SETUPS.item_class%TYPE;

486: v_rg23c_balance NUMBER;
487: v_pla_balance NUMBER;
488: v_order_type_id NUMBER;
489: v_excise_flag VARCHAR2(1);
490: v_item_class JAI_INV_ITM_SETUPS.item_class%TYPE;
491: v_modvat_tax_rate NUMBER;
492: v_rounding_factor NUMBER;
493: v_exempt_bal NUMBER;
494: v_basic_ed_amt NUMBER;

Line 519: FROM JAI_INV_ITM_SETUPS

515: AND B.Delivery_Detail_id = v_delivery_detail_id;
516:
517: CURSOR get_item_attributes IS
518: SELECT excise_flag, modvat_flag
519: FROM JAI_INV_ITM_SETUPS
520: WHERE inventory_item_id = v_Inventory_Item_Id
521: AND organization_id = v_organization_id;
522:
523: CURSOR Get_So_Lines_Count_Cur IS

Line 659: JAI_INV_ITM_SETUPS

655: CURSOR item_trading_cur IS
656: SELECT
657: item_trading_flag
658: FROM
659: JAI_INV_ITM_SETUPS
660: WHERE
661: organization_id = v_organization_id AND
662: inventory_item_id = v_inventory_item_id;
663:

Line 709: JAI_INV_ITM_SETUPS

705: SELECT
706: excise_flag,
707: item_class
708: FROM
709: JAI_INV_ITM_SETUPS
710: WHERE
711: organization_id = p_organization_id AND
712: inventory_item_id = p_item_id;
713:

Line 2842: JAI_INV_ITM_SETUPS

2838: CURSOR item_trading_cur IS
2839: SELECT
2840: item_trading_flag
2841: FROM
2842: JAI_INV_ITM_SETUPS
2843: WHERE
2844: organization_id = v_organization_id AND
2845: inventory_item_id = v_inventory_item_id;
2846:

Line 2849: FROM JAI_INV_ITM_SETUPS

2845: inventory_item_id = v_inventory_item_id;
2846:
2847: CURSOR get_item_attributes IS
2848: SELECT excise_flag, modvat_flag
2849: FROM JAI_INV_ITM_SETUPS
2850: WHERE inventory_item_id = v_Inventory_Item_Id
2851: AND organization_id = v_organization_id;
2852:
2853: BEGIN