eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INVIDIT3 dependencies on DUAL

Line 225: ,'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH'

221: ,'MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND'
222: ,'MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE'
223: ,'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE'
224: ,'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND'
225: ,'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH'
226: ,'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW'
227: ,'MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG'
228: ,'MTL_SYSTEM_ITEMS.LOT_DIVISIBLE_FLAG'
229: ,'MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG'

Line 226: ,'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW'

222: ,'MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE'
223: ,'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE'
224: ,'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND'
225: ,'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH'
226: ,'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW'
227: ,'MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG'
228: ,'MTL_SYSTEM_ITEMS.LOT_DIVISIBLE_FLAG'
229: ,'MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG'
230: ,'MTL_SYSTEM_ITEMS.RESERVABLE_TYPE'

Line 256: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH' THEN

252: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE' THEN
253: secondary_uom_level:= cur.control_level;
254: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND' THEN
255: sec_default_ind_level := cur.control_level;
256: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH' THEN
257: deviation_high_level := cur.control_level;
258: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW' THEN
259: deviation_low_level:= cur.control_level;
260: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG' THEN

Line 258: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW' THEN

254: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND' THEN
255: sec_default_ind_level := cur.control_level;
256: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH' THEN
257: deviation_high_level := cur.control_level;
258: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW' THEN
259: deviation_low_level:= cur.control_level;
260: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG' THEN
261: child_lot_level := cur.control_level;
262: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.LOT_DIVISIBLE_FLAG' THEN

Line 712: p_source_item => 'DUAL_UOM_DEVIATION_HIGH')) then

708: if (x_onhand_deviation_high <> 1) then
709: if (inv_attribute_control_pvt.check_pending_adjustments
710: (p_org_id => p_org_id,
711: p_item_id => p_item_id,
712: p_source_item => 'DUAL_UOM_DEVIATION_HIGH')) then
713: x_pendadj_deviation_high := 1;
714: end if;
715: end if;
716: if (x_onhand_deviation_low <> 1) then

Line 720: p_source_item => 'DUAL_UOM_DEVIATION_LOW')) then

716: if (x_onhand_deviation_low <> 1) then
717: if (inv_attribute_control_pvt.check_pending_adjustments
718: (p_org_id => p_org_id,
719: p_item_id => p_item_id,
720: p_source_item => 'DUAL_UOM_DEVIATION_LOW')) then
721: x_pendadj_deviation_low := 1;
722: end if;
723: end if;
724: if (x_onhand_child_lot <> 1) then

Line 753: from dual

749:
750: -- Check if on-hand quantity for the item exists in master and all child orgs.
751: if x_onhand_all IS NOT NULL THEN
752: select count(*) into X_onhand_all
753: from dual
754: where exists ( select 'x'
755: from mtl_onhand_quantities_detail moh -- Bug:2687570
756: where moh.inventory_item_id = p_item_id
757: and moh.organization_id in ( select mp.organization_id

Line 764: from dual

760: end if;
761:
762: if X_wip_repetitive_item IS NOT NULL THEN
763: select count(*) into X_wip_repetitive_item
764: from dual
765: where exists ( select 'x'
766: from WIP_REPETITIVE_ITEMS wri
767: where wri.PRIMARY_ITEM_ID = p_item_id
768: and wri.ORGANIZATION_ID in ( select mp.organization_id

Line 903: select count(*) into X_so_open_exists from dual

899: end if;
900:
901: -- Check for open sales order line for the item
902: IF X_so_open_exists IS NOT NULL THEN
903: select count(*) into X_so_open_exists from dual
904: where exists
905: ( select * from oe_order_lines_all
906: where inventory_item_id = p_item_id
907: and open_flag || '' = 'Y' );

Line 958: from dual

954: -- Use local variables for each sql statement, return 1 value to form
955: IF X_uom_conv IS NOT NULL THEN
956: select count(*)
957: into uom_conv
958: from dual
959: where exists
960: ( select 'x'
961: from mtl_uom_conversions
962: where inventory_item_id = p_item_id

Line 979: from sys.dual

975: if (uom_conv = 0) then
976:
977: select count(1)
978: into uom_other_conv
979: from sys.dual
980: where exists
981: (select 'x' from mtl_uom_conversions
982: where inventory_item_id = p_item_id)
983: or exists

Line 1038: /select count() into bom_row_exists from dual

1034: -- Check if a BOM is defined in master or any child orgs
1035: -- Used to determine if bom_item_type is updateable
1036: -- X_bom_exists will have either 0 or 1
1037:
1038: /*select count(*) into bom_row_exists from dual
1039: where exists
1040: ( select 'x' from bom_bill_of_materials bom
1041: where bom.assembly_item_id = p_item_id
1042: and bom.organization_id in

Line 1052: select count(*) into bom_row_exists from dual

1048:
1049: -- Added the bill existence check based on attribute control for BOM allowed
1050: -- as part of fix for bug#3451941.
1051: IF X_bom_exists IS NOT NULL THEN
1052: select count(*) into bom_row_exists from dual
1053: where exists
1054: ( select 'x' from bom_bill_of_materials bom
1055: where bom.assembly_item_id = p_item_id
1056: and bom.organization_id in