APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_INV_ITM_SETUPS

Line 215: JAI_INV_ITM_SETUPS

211: IS
212: SELECT
213: Item_Trading_Flag
214: FROM
215: JAI_INV_ITM_SETUPS
216: WHERE
217: organization_id = v_organization_id AND
218: inventory_item_id = v_inventory_item_id ;
219:

Line 263: JAI_INV_ITM_SETUPS jmsi -- Added by Brathod for Bug# 4299606 (DFF Elimination)

259: modvat_flag ,-- Commented attribute2 by Brathod for Bug# 4299606 (DFF Elimination)
260: nvl(container_item_flag,'N') --Added by Nagaraj.s for Bug3123613.
261: FROM
262: mtl_system_items msi,
263: JAI_INV_ITM_SETUPS jmsi -- Added by Brathod for Bug# 4299606 (DFF Elimination)
264: WHERE msi.organization_id = jmsi.organization_id
265: AND msi.inventory_item_id = jmsi.inventory_item_id
266: AND jmsi.inventory_item_id = v_Inventory_Item_Id -- Added by Brathod for Bug# 4299606 (DFF Elimination)
267: AND jmsi.organization_id = v_organization_id; -- Added by Brathod for Bug# 4299606 (DFF Elimination)

Line 599: mtl_system_items to corrosponding columns in JAI_INV_ITM_SETUPS

595: Issue:-
596: Item DFF Elimination
597: Fix:-
598: Changed the code that references attributeN (where N=1,2,3,4,5,15) of
599: mtl_system_items to corrosponding columns in JAI_INV_ITM_SETUPS
600:
601: Dependency :-
602: IN60106 + 4239736 (Service Tax) + 4245089 (VAT)
603:

Line 1109: v_item_class JAI_INV_ITM_SETUPS.item_class%TYPE;

1105: v_rg23c_balance NUMBER;
1106: v_pla_balance NUMBER;
1107: v_order_type_id NUMBER;
1108: v_excise_flag VARCHAR2(1);
1109: v_item_class JAI_INV_ITM_SETUPS.item_class%TYPE;
1110: v_modvat_tax_rate NUMBER;
1111: v_rounding_factor NUMBER;
1112: v_exempt_bal NUMBER;
1113: v_basic_ed_amt NUMBER;

Line 1162: FROM JAI_INV_ITM_SETUPS

1158: End of Bug# 4299606 */
1159: /* Added by Brathod for Bug# 4299606 */
1160: CURSOR get_item_attributes IS
1161: SELECT excise_flag, modvat_flag
1162: FROM JAI_INV_ITM_SETUPS
1163: WHERE inventory_item_id = v_Inventory_Item_Id
1164: AND organization_id = v_organization_id;
1165: /* End of Bug# 4299606 */
1166:

Line 1314: JAI_INV_ITM_SETUPS

1310: CURSOR item_trading_cur IS
1311: SELECT
1312: item_trading_flag
1313: FROM
1314: JAI_INV_ITM_SETUPS
1315: WHERE
1316: organization_id = v_organization_id AND
1317: inventory_item_id = v_inventory_item_id;
1318:

Line 1373: JAI_INV_ITM_SETUPS

1369: SELECT
1370: excise_flag,
1371: item_class
1372: FROM
1373: JAI_INV_ITM_SETUPS
1374: WHERE
1375: organization_id = p_organization_id AND
1376: inventory_item_id = p_item_id;
1377:

Line 1876: mtl_system_items to corrosponding columns in JAI_INV_ITM_SETUPS

1872: Issue:-
1873: Item DFF Elimination
1874: Fix:-
1875: Changed the code that references attributeN (where N=1,2,3,4,5,15) of
1876: mtl_system_items to corrosponding columns in JAI_INV_ITM_SETUPS
1877:
1878: Dependency :-
1879: IN60106 + 4239736 (Service Tax) + 4245089 (VAT)
1880: