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_B

Line 1346: FROM mtl_system_items_b msi,

1342: THEN
1343:
1344: SELECT null
1345: INTO l_dummy
1346: FROM mtl_system_items_b msi,
1347: org_organization_definitions org
1348: WHERE msi.inventory_item_id = p_inventory_item_id
1349: AND org.organization_id= msi.organization_id
1350: AND msi.customer_order_enabled_flag =

Line 1358: FROM mtl_system_items_b msi,

1354: AND org.organization_id= p_ship_from_org_id;
1355: ELSE
1356: SELECT null
1357: INTO l_dummy
1358: FROM mtl_system_items_b msi,
1359: org_organization_definitions org
1360: WHERE msi.inventory_item_id = p_inventory_item_id
1361: AND org.organization_id= msi.organization_id
1362: AND msi.customer_order_enabled_flag =

Line 1401: FROM mtl_system_items_b a,mtl_system_items_b b

1397: IF(Nvl(p_line_rec.shipping_interfaced_flag,'N') = 'Y') THEN
1398: BEGIN
1399: SELECT a.shippable_item_flag, b.shippable_item_flag
1400: INTO l_shipable_flag_old,l_shipable_flag_new
1401: FROM mtl_system_items_b a,mtl_system_items_b b
1402: WHERE a.inventory_item_id = p_line_rec.inventory_item_id
1403: AND b.inventory_item_id = a.inventory_item_id
1404: AND a.organization_id = p_old_line_rec.ship_from_org_id
1405: AND b.organization_id = p_line_rec.ship_from_org_id;

Line 1461: FROM mtl_system_items_b msi,

1457: /* Internal Orders only support standard item */
1458: THEN
1459: SELECT null
1460: INTO l_dummy
1461: FROM mtl_system_items_b msi,
1462: org_organization_definitions org
1463: WHERE msi.inventory_item_id = p_inventory_item_id
1464: AND org.organization_id= msi.organization_id
1465: AND msi.internal_order_enabled_flag = 'Y'

Line 1475: FROM mtl_system_items_b msi,

1471: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG
1472: THEN
1473: SELECT null
1474: INTO l_dummy
1475: FROM mtl_system_items_b msi,
1476: org_organization_definitions org
1477: WHERE msi.inventory_item_id = p_inventory_item_id
1478: AND org.organization_id= msi.organization_id
1479: AND sysdate <= nvl( org.disable_date, sysdate)

Line 1491: FROM mtl_system_items_b msi,

1487: THEN
1488: --Commented for bug 4343544 start
1489: /*SELECT null
1490: INTO l_dummy
1491: FROM mtl_system_items_b msi,
1492: org_organization_definitions org
1493: WHERE msi.inventory_item_id = p_inventory_item_id
1494: AND org.organization_id= msi.organization_id
1495: AND sysdate <= nvl( org.disable_date, sysdate)

Line 1506: FROM mtl_system_items_b msi,

1502: --Added for bug 4343544 start changed decode for better performance
1503: if g_cust_ord_enabled_flag='Y' then
1504: SELECT null
1505: INTO l_dummy
1506: FROM mtl_system_items_b msi,
1507: org_organization_definitions org
1508: WHERE msi.inventory_item_id = p_inventory_item_id
1509: AND org.organization_id= msi.organization_id
1510: AND sysdate <= nvl( org.disable_date, sysdate)

Line 1517: FROM mtl_system_items_b msi,

1513: AND rownum=1;
1514: else
1515: SELECT null
1516: INTO l_dummy
1517: FROM mtl_system_items_b msi,
1518: org_organization_definitions org
1519: WHERE msi.inventory_item_id = p_inventory_item_id
1520: AND org.organization_id= msi.organization_id
1521: AND sysdate <= nvl( org.disable_date, sysdate)

Line 1529: FROM mtl_system_items_b msi,

1525: --Added for bug 4343544 end
1526: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
1527: SELECT null
1528: INTO l_dummy
1529: FROM mtl_system_items_b msi,
1530: org_organization_definitions org
1531: WHERE msi.inventory_item_id = p_inventory_item_id
1532: AND org.organization_id= msi.organization_id
1533: AND msi.customer_order_enabled_flag = 'Y'

Line 1725: FROM mtl_system_items_b

1721: /* Internal Orders only support standard item */
1722: THEN
1723: SELECT 'valid'
1724: INTO l_dummy
1725: FROM mtl_system_items_b
1726: WHERE inventory_item_id = p_inventory_item_id
1727: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1728: AND internal_order_enabled_flag = 'Y';
1729: ELSE /* other orders except Internal*/

Line 1739: FROM mtl_system_items_b

1735: nvl(p_top_model_line_id, -1) <> p_line_id)
1736: THEN
1737: SELECT 'valid'
1738: INTO l_dummy
1739: FROM mtl_system_items_b
1740: WHERE inventory_item_id = p_inventory_item_id
1741: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
1742: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
1743:

Line 1778: FROM mtl_system_items_b

1774: END IF ;
1775:
1776: /*SELECT 'valid'
1777: INTO l_dummy
1778: FROM mtl_system_items_b
1779: WHERE inventory_item_id = p_inventory_item_id
1780: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1781: AND customer_order_enabled_flag = 'Y'; */
1782: -- end bug 4171642

Line 1809: FROM mtl_system_items_b

1805: -- bug 4171642
1806:
1807: /*SELECT 'valid'
1808: INTO l_dummy
1809: FROM mtl_system_items_b
1810: WHERE inventory_item_id = p_inventory_item_id
1811: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1812: AND customer_order_enabled_flag = 'Y'; */
1813: -- End bug 4171642

Line 2084: FROM mtl_system_items_b

2080: END IF ;
2081: /*
2082: SELECT nvl(returnable_flag,'Y')
2083: INTO l_returnable_flag
2084: FROM mtl_system_items_b
2085: WHERE inventory_item_id = p_inventory_item_id
2086: and organization_id = nvl(p_ship_from_org_id,
2087: oe_sys_parameters.value_wnps('MASTER_ORGANIZATION_ID')); */
2088:

Line 6286: FROM mtl_system_items_b

6282: END IF ;
6283: end of bug 8894555,8704697 */
6284: /*SELECT primary_uom_code
6285: INTO l_uom
6286: FROM mtl_system_items_b
6287: WHERE inventory_item_id = p_line_rec.inventory_item_id
6288: AND organization_id = nvl(p_line_rec.ship_from_org_id,
6289: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
6290: */

Line 8022: FROM mtl_system_items_b

8018: IF p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM or p_line_rec.ship_from_org_id is NULL
8019: THEN
8020: SELECT primary_uom_code
8021: INTO l_uom
8022: FROM mtl_system_items_b
8023: WHERE inventory_item_id = p_line_rec.inventory_item_id
8024: AND organization_id = l_mast_org_id
8025: and rownum=1;
8026: ELSE

Line 8029: FROM mtl_system_items_b

8025: and rownum=1;
8026: ELSE
8027: SELECT primary_uom_code
8028: INTO l_uom
8029: FROM mtl_system_items_b
8030: WHERE inventory_item_id = p_line_rec.inventory_item_id
8031: AND organization_id = p_line_rec.ship_from_org_id
8032: and rownum=1;
8033: END IF;