APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on MTL_SYSTEM_ITEMS

Line 198: v_container_item_flag mtl_system_items.container_item_flag%type ;

194: v_item_trading_flag VARCHAR2(1) ;
195: v_location_id NUMBER ;
196: v_exe_flag VARCHAR2(150) ;
197: v_mod_flag VARCHAR2(150) ;
198: v_container_item_flag mtl_system_items.container_item_flag%type ;
199: lv_inventory_item_flag mtl_system_items.inventory_item_flag%type ;/*added by csahoo for bug#8500697*/
200:
201: /*
202: ||Added by bgowrava for the forward porting bug 5631784 (TCS enhancement)

Line 199: lv_inventory_item_flag mtl_system_items.inventory_item_flag%type ;/*added by csahoo for bug#8500697*/

195: v_location_id NUMBER ;
196: v_exe_flag VARCHAR2(150) ;
197: v_mod_flag VARCHAR2(150) ;
198: v_container_item_flag mtl_system_items.container_item_flag%type ;
199: lv_inventory_item_flag mtl_system_items.inventory_item_flag%type ;/*added by csahoo for bug#8500697*/
200:
201: /*
202: ||Added by bgowrava for the forward porting bug 5631784 (TCS enhancement)
203: */

Line 285: mtl_system_items msi,

281: modvat_flag ,-- Commented attribute2 by Brathod for Bug# 4299606 (DFF Elimination)
282: nvl(container_item_flag,'N'), --Added by Nagaraj.s for Bug3123613.
283: nvl(inventory_item_flag,'N') --added by csahoo for bug#8500697
284: FROM
285: mtl_system_items msi,
286: JAI_INV_ITM_SETUPS jmsi -- Added by Brathod for Bug# 4299606 (DFF Elimination)
287: WHERE msi.organization_id = jmsi.organization_id
288: AND msi.inventory_item_id = jmsi.inventory_item_id
289: AND jmsi.inventory_item_id = v_Inventory_Item_Id -- Added by Brathod for Bug# 4299606 (DFF Elimination)

Line 677: mtl_system_items to corrosponding columns in JAI_INV_ITM_SETUPS

673: Issue:-
674: Item DFF Elimination
675: Fix:-
676: Changed the code that references attributeN (where N=1,2,3,4,5,15) of
677: mtl_system_items to corrosponding columns in JAI_INV_ITM_SETUPS
678:
679: Dependency :-
680: IN60106 + 4239736 (Service Tax) + 4245089 (VAT)
681:

Line 1387: FROM mtl_system_items

1383: --Added by GSRI for BUG 2283066
1384: /* Commented by Brathod for Bug# 4299606 (DFF Elimination)*/
1385: /* CURSOR get_item_attributes IS
1386: SELECT attribute1 ,attribute2
1387: FROM mtl_system_items
1388: WHERE inventory_item_id = v_Inventory_Item_Id
1389: AND organization_id = v_organization_id;
1390: End of Bug# 4299606 */
1391: /* Added by Brathod for Bug# 4299606 */

Line 2116: mtl_system_items to corrosponding columns in JAI_INV_ITM_SETUPS

2112: Issue:-
2113: Item DFF Elimination
2114: Fix:-
2115: Changed the code that references attributeN (where N=1,2,3,4,5,15) of
2116: mtl_system_items to corrosponding columns in JAI_INV_ITM_SETUPS
2117:
2118: Dependency :-
2119: IN60106 + 4239736 (Service Tax) + 4245089 (VAT)
2120: