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 239: ,'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH'

235: ,'MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND'
236: ,'MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE'
237: ,'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE'
238: ,'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND'
239: ,'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH'
240: ,'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW'
241: ,'MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG'
242: ,'MTL_SYSTEM_ITEMS.LOT_DIVISIBLE_FLAG'
243: ,'MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG'

Line 240: ,'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW'

236: ,'MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE'
237: ,'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE'
238: ,'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND'
239: ,'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH'
240: ,'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW'
241: ,'MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG'
242: ,'MTL_SYSTEM_ITEMS.LOT_DIVISIBLE_FLAG'
243: ,'MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG'
244: ,'MTL_SYSTEM_ITEMS.RESERVABLE_TYPE'

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

266: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE' THEN
267: secondary_uom_level:= cur.control_level;
268: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND' THEN
269: sec_default_ind_level := cur.control_level;
270: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH' THEN
271: deviation_high_level := cur.control_level;
272: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW' THEN
273: deviation_low_level:= cur.control_level;
274: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG' THEN

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

268: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND' THEN
269: sec_default_ind_level := cur.control_level;
270: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH' THEN
271: deviation_high_level := cur.control_level;
272: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW' THEN
273: deviation_low_level:= cur.control_level;
274: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG' THEN
275: child_lot_level := cur.control_level;
276: ELSIF cur.attribute_name = 'MTL_SYSTEM_ITEMS.LOT_DIVISIBLE_FLAG' THEN

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

742: if (x_onhand_deviation_high <> 1) then
743: if (inv_attribute_control_pvt.check_pending_adjustments
744: (p_org_id => p_org_id,
745: p_item_id => p_item_id,
746: p_source_item => 'DUAL_UOM_DEVIATION_HIGH')) then
747: x_pendadj_deviation_high := 1;
748: end if;
749: end if;
750: if (x_onhand_deviation_low <> 1) then

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

750: if (x_onhand_deviation_low <> 1) then
751: if (inv_attribute_control_pvt.check_pending_adjustments
752: (p_org_id => p_org_id,
753: p_item_id => p_item_id,
754: p_source_item => 'DUAL_UOM_DEVIATION_LOW')) then
755: x_pendadj_deviation_low := 1;
756: end if;
757: end if;
758: if (x_onhand_child_lot <> 1) then

Line 787: from dual

783:
784: -- Check if on-hand quantity for the item exists in master and all child orgs.
785: if x_onhand_all IS NOT NULL THEN
786: select count(*) into X_onhand_all
787: from dual
788: where exists ( select 'x'
789: from mtl_onhand_quantities_detail moh -- Bug:2687570
790: where moh.inventory_item_id = p_item_id
791: and moh.organization_id in ( select mp.organization_id

Line 798: from dual

794: end if;
795:
796: if X_wip_repetitive_item IS NOT NULL THEN
797: select count(*) into X_wip_repetitive_item
798: from dual
799: where exists ( select 'x'
800: from WIP_REPETITIVE_ITEMS wri
801: where wri.PRIMARY_ITEM_ID = p_item_id
802: and wri.ORGANIZATION_ID in ( select mp.organization_id

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

972: end if;*/
973:
974: -- Check for open sales order line for the item
975: IF X_so_open_exists IS NOT NULL THEN
976: select count(*) into X_so_open_exists from dual
977: where exists
978: ( select * from oe_order_lines_all
979: where inventory_item_id = p_item_id
980: and open_flag = 'Y' -- Bug 8435071

Line 1032: from dual

1028: -- Use local variables for each sql statement, return 1 value to form
1029: IF X_uom_conv IS NOT NULL THEN
1030: select count(*)
1031: into uom_conv
1032: from dual
1033: where exists
1034: ( select 'x'
1035: from mtl_uom_conversions
1036: where inventory_item_id = p_item_id

Line 1053: from sys.dual

1049: if (uom_conv = 0) then
1050:
1051: select count(1)
1052: into uom_other_conv
1053: from sys.dual
1054: where exists
1055: (select 'x' from mtl_uom_conversions
1056: where inventory_item_id = p_item_id)
1057: or exists

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

1108: -- Check if a BOM is defined in master or any child orgs
1109: -- Used to determine if bom_item_type is updateable
1110: -- X_bom_exists will have either 0 or 1
1111:
1112: /*select count(*) into bom_row_exists from dual
1113: where exists
1114: ( select 'x' from bom_bill_of_materials bom
1115: where bom.assembly_item_id = p_item_id
1116: and bom.organization_id in

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

1122:
1123: -- Added the bill existence check based on attribute control for BOM allowed
1124: -- as part of fix for bug#3451941.
1125: IF X_bom_exists IS NOT NULL THEN
1126: select count(*) into bom_row_exists from dual
1127: where exists
1128: ( select 'x' from bom_bill_of_materials bom
1129: where bom.assembly_item_id = p_item_id
1130: and bom.organization_id in