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.OE_VALIDATE_LINE dependencies on MTL_SYSTEM_ITEMS

Line 692: from mtl_system_items

688: p_line_rec.item_revision IS NULL THEN
689: Begin
690: select decode(revision_qty_control_code, 2, 'Y', 'N')
691: into l_revision_controlled
692: from mtl_system_items
693: where inventory_item_id = p_line_rec.inventory_item_id
694: and organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
695: Exception
696: When NO_DATA_FOUND Then

Line 1077: FROM mtl_system_items

1073: END IF;
1074:
1075: SELECT INDIVISIBLE_FLAG
1076: INTO l_indivisible_flag
1077: FROM mtl_system_items
1078: WHERE inventory_item_id = p_line_rec.inventory_item_id
1079: AND organization_id =
1080: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1081:

Line 1322: FROM mtl_system_items_b msi,

1318: THEN
1319:
1320: SELECT null
1321: INTO l_dummy
1322: FROM mtl_system_items_b msi,
1323: org_organization_definitions org
1324: WHERE msi.inventory_item_id = p_inventory_item_id
1325: AND org.organization_id= msi.organization_id
1326: AND msi.customer_order_enabled_flag =

Line 1334: FROM mtl_system_items_b msi,

1330: AND org.organization_id= p_ship_from_org_id;
1331: ELSE
1332: SELECT null
1333: INTO l_dummy
1334: FROM mtl_system_items_b msi,
1335: org_organization_definitions org
1336: WHERE msi.inventory_item_id = p_inventory_item_id
1337: AND org.organization_id= msi.organization_id
1338: AND msi.customer_order_enabled_flag =

Line 1377: FROM mtl_system_items_b a,mtl_system_items_b b

1373: IF(Nvl(p_line_rec.shipping_interfaced_flag,'N') = 'Y') THEN
1374: BEGIN
1375: SELECT a.shippable_item_flag, b.shippable_item_flag
1376: INTO l_shipable_flag_old,l_shipable_flag_new
1377: FROM mtl_system_items_b a,mtl_system_items_b b
1378: WHERE a.inventory_item_id = p_line_rec.inventory_item_id
1379: AND b.inventory_item_id = a.inventory_item_id
1380: AND a.organization_id = p_old_line_rec.ship_from_org_id
1381: AND b.organization_id = p_line_rec.ship_from_org_id;

Line 1437: FROM mtl_system_items_b msi,

1433: /* Internal Orders only support standard item */
1434: THEN
1435: SELECT null
1436: INTO l_dummy
1437: FROM mtl_system_items_b msi,
1438: org_organization_definitions org
1439: WHERE msi.inventory_item_id = p_inventory_item_id
1440: AND org.organization_id= msi.organization_id
1441: AND msi.internal_order_enabled_flag = 'Y'

Line 1451: FROM mtl_system_items_b msi,

1447: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG
1448: THEN
1449: SELECT null
1450: INTO l_dummy
1451: FROM mtl_system_items_b msi,
1452: org_organization_definitions org
1453: WHERE msi.inventory_item_id = p_inventory_item_id
1454: AND org.organization_id= msi.organization_id
1455: AND sysdate <= nvl( org.disable_date, sysdate)

Line 1467: FROM mtl_system_items_b msi,

1463: THEN
1464: --Commented for bug 4343544 start
1465: /*SELECT null
1466: INTO l_dummy
1467: FROM mtl_system_items_b msi,
1468: org_organization_definitions org
1469: WHERE msi.inventory_item_id = p_inventory_item_id
1470: AND org.organization_id= msi.organization_id
1471: AND sysdate <= nvl( org.disable_date, sysdate)

Line 1482: FROM mtl_system_items_b msi,

1478: --Added for bug 4343544 start changed decode for better performance
1479: if g_cust_ord_enabled_flag='Y' then
1480: SELECT null
1481: INTO l_dummy
1482: FROM mtl_system_items_b msi,
1483: org_organization_definitions org
1484: WHERE msi.inventory_item_id = p_inventory_item_id
1485: AND org.organization_id= msi.organization_id
1486: AND sysdate <= nvl( org.disable_date, sysdate)

Line 1493: FROM mtl_system_items_b msi,

1489: AND rownum=1;
1490: else
1491: SELECT null
1492: INTO l_dummy
1493: FROM mtl_system_items_b msi,
1494: org_organization_definitions org
1495: WHERE msi.inventory_item_id = p_inventory_item_id
1496: AND org.organization_id= msi.organization_id
1497: AND sysdate <= nvl( org.disable_date, sysdate)

Line 1505: FROM mtl_system_items_b msi,

1501: --Added for bug 4343544 end
1502: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
1503: SELECT null
1504: INTO l_dummy
1505: FROM mtl_system_items_b msi,
1506: org_organization_definitions org
1507: WHERE msi.inventory_item_id = p_inventory_item_id
1508: AND org.organization_id= msi.organization_id
1509: AND msi.customer_order_enabled_flag = 'Y'

Line 1640: , mtl_system_items_vl sitems

1636: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1637: DECODE(items.organization_id, item_val_org, 1, 2))
1638: FROM mtl_cross_reference_types types
1639: , mtl_cross_references items
1640: , mtl_system_items_vl sitems
1641: WHERE types.cross_reference_type = items.cross_reference_type
1642: AND items.inventory_item_id = sitems.inventory_item_id
1643: AND sitems.organization_id = item_val_org
1644: AND sitems.inventory_item_id = p_inventory_item_id

Line 1657: , mtl_system_items_vl sitems

1653: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1654: DECODE(items.organization_id, item_val_org, 1, 2))
1655: FROM mtl_cross_reference_types types
1656: , mtl_cross_references items
1657: , mtl_system_items_vl sitems
1658: WHERE types.cross_reference_type = items.cross_reference_type
1659: AND items.inventory_item_id = sitems.inventory_item_id
1660: AND sitems.organization_id = item_val_org
1661: AND sitems.inventory_item_id = p_inventory_item_id

Line 1701: FROM mtl_system_items_b

1697: /* Internal Orders only support standard item */
1698: THEN
1699: SELECT 'valid'
1700: INTO l_dummy
1701: FROM mtl_system_items_b
1702: WHERE inventory_item_id = p_inventory_item_id
1703: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1704: AND internal_order_enabled_flag = 'Y';
1705: ELSE /* other orders except Internal*/

Line 1715: FROM mtl_system_items_b

1711: nvl(p_top_model_line_id, -1) <> p_line_id)
1712: THEN
1713: SELECT 'valid'
1714: INTO l_dummy
1715: FROM mtl_system_items_b
1716: WHERE inventory_item_id = p_inventory_item_id
1717: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
1718: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
1719:

Line 1754: FROM mtl_system_items_b

1750: END IF ;
1751:
1752: /*SELECT 'valid'
1753: INTO l_dummy
1754: FROM mtl_system_items_b
1755: WHERE inventory_item_id = p_inventory_item_id
1756: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1757: AND customer_order_enabled_flag = 'Y'; */
1758: -- end bug 4171642

Line 1785: FROM mtl_system_items_b

1781: -- bug 4171642
1782:
1783: /*SELECT 'valid'
1784: INTO l_dummy
1785: FROM mtl_system_items_b
1786: WHERE inventory_item_id = p_inventory_item_id
1787: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1788: AND customer_order_enabled_flag = 'Y'; */
1789: -- End bug 4171642

Line 1806: ,mtl_system_items_vl sitems

1802: SELECT 'valid'
1803: INTO l_dummy
1804: FROM mtl_customer_items citems
1805: ,mtl_customer_item_xrefs cxref
1806: ,mtl_system_items_vl sitems
1807: ,mtl_parameters mp -- 4402603
1808: WHERE citems.customer_item_id = cxref.customer_item_id
1809: AND cxref.inventory_item_id = sitems.inventory_item_id
1810: AND sitems.inventory_item_id = p_inventory_item_id

Line 1827: ,mtl_system_items_vl sitems

1823: SELECT 'valid'
1824: INTO l_dummy
1825: FROM mtl_customer_items citems
1826: ,mtl_customer_item_xrefs cxref
1827: ,mtl_system_items_vl sitems
1828: ,mtl_parameters mp -- 4402603
1829: WHERE citems.customer_item_id = cxref.customer_item_id
1830: AND cxref.inventory_item_id = sitems.inventory_item_id
1831: AND sitems.inventory_item_id = p_inventory_item_id

Line 2059: FROM mtl_system_items_b

2055: END IF ;
2056: /*
2057: SELECT nvl(returnable_flag,'Y')
2058: INTO l_returnable_flag
2059: FROM mtl_system_items_b
2060: WHERE inventory_item_id = p_inventory_item_id
2061: and organization_id = nvl(p_ship_from_org_id,
2062: oe_sys_parameters.value_wnps('MASTER_ORGANIZATION_ID')); */
2063:

Line 2748: FROM mtl_system_items msi,

2744: THEN
2745:
2746: SELECT purchasing_enabled_flag
2747: INTO l_purchasing_enabled_flag
2748: FROM mtl_system_items msi,
2749: org_organization_definitions org
2750: WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
2751: AND org.organization_id= msi.organization_id
2752: AND sysdate <= nvl( org.disable_date, sysdate)

Line 2761: FROM mtl_system_items msi,

2757: END IF;
2758: ELSE
2759: SELECT purchasing_enabled_flag
2760: INTO l_purchasing_enabled_flag
2761: FROM mtl_system_items msi,
2762: org_organization_definitions org
2763: WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
2764: AND org.organization_id= msi.organization_id
2765: AND sysdate <= nvl( org.disable_date, sysdate)

Line 4082: FROM MTL_SYSTEM_ITEMS

4078: end if ;
4079: end if ;
4080: /*SELECT RESTRICT_SUBINVENTORIES_CODE
4081: INTO l_restrict_subinv
4082: FROM MTL_SYSTEM_ITEMS
4083: WHERE inventory_item_id = p_line_rec.inventory_item_id
4084: AND organization_id = p_line_rec.ship_from_org_id;*/
4085: -- bug 4171642
4086: EXCEPTION

Line 4121: from mtl_system_items

4117: OR
4118: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
4119: and nvl(p_line_rec.order_source_id, -1) = 10
4120: and 'N' = (select inventory_asset_flag
4121: from mtl_system_items
4122: where inventory_item_id = p_line_rec.inventory_item_id
4123: and organization_id = p_line_rec.ship_from_org_id)
4124: )
4125: OR

Line 4129: from mtl_system_items

4125: OR
4126: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
4127: and nvl(p_line_rec.order_source_id, -1) = 10
4128: and 'Y' = (select inventory_asset_flag
4129: from mtl_system_items
4130: where inventory_item_id = p_line_rec.inventory_item_id
4131: and organization_id = p_line_rec.ship_from_org_id)
4132: and sub.asset_inventory = 1
4133: )

Line 5944: FROM mtl_system_items_b

5940: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
5941: END IF ;
5942: /*SELECT primary_uom_code
5943: INTO l_uom
5944: FROM mtl_system_items_b
5945: WHERE inventory_item_id = p_line_rec.inventory_item_id
5946: AND organization_id = nvl(p_line_rec.ship_from_org_id,
5947: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
5948: */

Line 7435: --FROM MTL_SYSTEM_ITEMS mtl_msi

7431: END IF;
7432:
7433: --SELECT description
7434: --INTO l_item_description
7435: --FROM MTL_SYSTEM_ITEMS mtl_msi
7436: --WHERE mtl_msi.inventory_item_id = p_line_rec.inventory_item_id
7437: --AND mtl_msi.organization_id =
7438: -- OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
7439:

Line 7611: FROM mtl_system_items_b

7607: IF p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM or p_line_rec.ship_from_org_id is NULL
7608: THEN
7609: SELECT primary_uom_code
7610: INTO l_uom
7611: FROM mtl_system_items_b
7612: WHERE inventory_item_id = p_line_rec.inventory_item_id
7613: AND organization_id = l_mast_org_id
7614: and rownum=1;
7615: ELSE

Line 7618: FROM mtl_system_items_b

7614: and rownum=1;
7615: ELSE
7616: SELECT primary_uom_code
7617: INTO l_uom
7618: FROM mtl_system_items_b
7619: WHERE inventory_item_id = p_line_rec.inventory_item_id
7620: AND organization_id = p_line_rec.ship_from_org_id
7621: and rownum=1;
7622: END IF;