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 716: from mtl_system_items

712: p_line_rec.item_revision IS NULL THEN
713: Begin
714: select decode(revision_qty_control_code, 2, 'Y', 'N')
715: into l_revision_controlled
716: from mtl_system_items
717: where inventory_item_id = p_line_rec.inventory_item_id
718: and organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
719: Exception
720: When NO_DATA_FOUND Then

Line 1101: FROM mtl_system_items

1097: END IF;
1098:
1099: SELECT INDIVISIBLE_FLAG
1100: INTO l_indivisible_flag
1101: FROM mtl_system_items
1102: WHERE inventory_item_id = p_line_rec.inventory_item_id
1103: AND organization_id =
1104: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1105:

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 1664: , mtl_system_items_vl sitems

1660: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1661: DECODE(items.organization_id, item_val_org, 1, 2))
1662: FROM mtl_cross_reference_types types
1663: , mtl_cross_references items
1664: , mtl_system_items_vl sitems
1665: WHERE types.cross_reference_type = items.cross_reference_type
1666: AND items.inventory_item_id = sitems.inventory_item_id
1667: AND sitems.organization_id = item_val_org
1668: AND sitems.inventory_item_id = p_inventory_item_id

Line 1681: , mtl_system_items_vl sitems

1677: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1678: DECODE(items.organization_id, item_val_org, 1, 2))
1679: FROM mtl_cross_reference_types types
1680: , mtl_cross_references items
1681: , mtl_system_items_vl sitems
1682: WHERE types.cross_reference_type = items.cross_reference_type
1683: AND items.inventory_item_id = sitems.inventory_item_id
1684: AND sitems.organization_id = item_val_org
1685: AND sitems.inventory_item_id = p_inventory_item_id

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 1830: ,mtl_system_items_vl sitems

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

Line 1851: ,mtl_system_items_vl sitems

1847: SELECT 'valid'
1848: INTO l_dummy
1849: FROM mtl_customer_items citems
1850: ,mtl_customer_item_xrefs cxref
1851: ,mtl_system_items_vl sitems
1852: ,mtl_parameters mp -- 4402603
1853: WHERE citems.customer_item_id = cxref.customer_item_id
1854: AND cxref.inventory_item_id = sitems.inventory_item_id
1855: AND sitems.inventory_item_id = p_inventory_item_id

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 2873: FROM mtl_system_items msi,

2869: THEN
2870:
2871: SELECT purchasing_enabled_flag
2872: INTO l_purchasing_enabled_flag
2873: FROM mtl_system_items msi,
2874: org_organization_definitions org
2875: WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
2876: AND org.organization_id= msi.organization_id
2877: AND sysdate <= nvl( org.disable_date, sysdate)

Line 2886: FROM mtl_system_items msi,

2882: END IF;
2883: ELSE
2884: SELECT purchasing_enabled_flag
2885: INTO l_purchasing_enabled_flag
2886: FROM mtl_system_items msi,
2887: org_organization_definitions org
2888: WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
2889: AND org.organization_id= msi.organization_id
2890: AND sysdate <= nvl( org.disable_date, sysdate)

Line 4110: FROM MTL_SYSTEM_ITEMS I,OE_ORDER_LINES L

4106: IF P_LINE_REC.service_reference_type_code = 'ORDER' AND P_LINE_REC.service_reference_line_id IS NOT NULL AND P_LINE_REC.service_reference_line_id <> FND_API.G_MISS_NUM THEN
4107:
4108: SELECT I.SERVICEABLE_PRODUCT_FLAG,L.flow_status_code INTO
4109: l_serviceable_product_flag,l_flow_status_code
4110: FROM MTL_SYSTEM_ITEMS I,OE_ORDER_LINES L
4111: WHERE I.INVENTORY_ITEM_ID = L.inventory_item_id
4112: AND I.ORGANIZATION_ID = g_master_org_id
4113: AND L.LINE_ID = P_LINE_REC.service_reference_line_id;
4114:

Line 4382: FROM MTL_SYSTEM_ITEMS

4378: end if ;
4379: end if ;
4380: /*SELECT RESTRICT_SUBINVENTORIES_CODE
4381: INTO l_restrict_subinv
4382: FROM MTL_SYSTEM_ITEMS
4383: WHERE inventory_item_id = p_line_rec.inventory_item_id
4384: AND organization_id = p_line_rec.ship_from_org_id;*/
4385: -- bug 4171642
4386: EXCEPTION

Line 4421: from mtl_system_items

4417: OR
4418: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
4419: and nvl(p_line_rec.order_source_id, -1) = 10
4420: and 'N' = (select inventory_asset_flag
4421: from mtl_system_items
4422: where inventory_item_id = p_line_rec.inventory_item_id
4423: and organization_id = p_line_rec.ship_from_org_id)
4424: )
4425: OR

Line 4429: from mtl_system_items

4425: OR
4426: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
4427: and nvl(p_line_rec.order_source_id, -1) = 10
4428: and 'Y' = (select inventory_asset_flag
4429: from mtl_system_items
4430: where inventory_item_id = p_line_rec.inventory_item_id
4431: and organization_id = p_line_rec.ship_from_org_id)
4432: and sub.asset_inventory = 1
4433: )

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 6310: FROM mtl_system_items

6306: ELSE
6307:
6308: SELECT primary_uom_code
6309: INTO l_uom
6310: FROM mtl_system_items
6311: WHERE inventory_item_id = p_line_rec.inventory_item_id
6312: AND organization_id = g_master_org_id ;
6313:
6314: if l_debug_level > 0 then

Line 7833: --FROM MTL_SYSTEM_ITEMS mtl_msi

7829: END IF;
7830:
7831: --SELECT description
7832: --INTO l_item_description
7833: --FROM MTL_SYSTEM_ITEMS mtl_msi
7834: --WHERE mtl_msi.inventory_item_id = p_line_rec.inventory_item_id
7835: --AND mtl_msi.organization_id =
7836: -- OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
7837:

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;