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_OE_FORM_LINE dependencies on MTL_SYSTEM_ITEMS_VL

Line 3862: FROM mtl_system_items_vl

3858: ,concatenated_segments /*Bug 1766327 chhung*/
3859: INTO x_line_val_rec.item_description
3860: ,x_line_val_rec.ordered_item_dsp
3861: ,x_line_val_rec.inventory_item /*bug 1766327 chhung*/
3862: FROM mtl_system_items_vl
3863: WHERE inventory_item_id = p_line_rec.inventory_item_id
3864: AND organization_id = l_organization_id;
3865: IF l_debug_level > 0 THEN
3866: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;

Line 3892: ,mtl_system_items_vl sitems

3888: ,x_line_val_rec.ordered_item_dsp
3889: ,x_line_val_rec.inventory_item /*Bug 1766327 chhung*/
3890: FROM mtl_customer_items citems
3891: ,mtl_customer_item_xrefs cxref
3892: ,mtl_system_items_vl sitems
3893: ,mtl_parameters mp -- bug 3918771
3894: WHERE citems.customer_item_id = cxref.customer_item_id
3895: AND cxref.inventory_item_id = sitems.inventory_item_id
3896: AND sitems.inventory_item_id = p_line_rec.inventory_item_id

Line 3921: FROM mtl_system_items_vl

3917: ,concatenated_segments
3918: INTO x_line_val_rec.item_description
3919: ,x_line_val_rec.ordered_item_dsp
3920: ,x_line_val_rec.inventory_item
3921: FROM mtl_system_items_vl
3922: WHERE inventory_item_id = p_line_rec.inventory_item_id
3923: AND organization_id = l_organization_id;
3924:
3925: IF l_debug_level > 0 THEN

Line 3955: , mtl_system_items_vl sitems

3951: ,x_line_val_rec.ordered_item_dsp
3952: ,x_line_val_rec.inventory_item /*Bug 1766327 chhung*/
3953: FROM mtl_cross_reference_types types
3954: , mtl_cross_references items
3955: , mtl_system_items_vl sitems
3956: WHERE types.cross_reference_type = items.cross_reference_type
3957: AND items.inventory_item_id = sitems.inventory_item_id
3958: AND sitems.organization_id = l_organization_id
3959: AND sitems.inventory_item_id = p_line_rec.inventory_item_id

Line 3982: FROM mtl_system_items_vl

3978: ,concatenated_segments
3979: INTO x_line_val_rec.item_description
3980: ,x_line_val_rec.ordered_item_dsp
3981: ,x_line_val_rec.inventory_item
3982: FROM mtl_system_items_vl
3983: WHERE inventory_item_id = p_line_rec.inventory_item_id
3984: AND organization_id = l_organization_id;
3985:
3986: IF l_debug_level > 0 THEN

Line 4004: ,mtl_system_items_vl sitems

4000: ,x_line_val_rec.ordered_item_dsp
4001: ,x_line_val_rec.inventory_item
4002: FROM mtl_cross_reference_types types
4003: ,mtl_cross_references items
4004: ,mtl_system_items_vl sitems
4005: WHERE types.cross_reference_type = items.cross_reference_type
4006: AND items.inventory_item_id = sitems.inventory_item_id
4007: AND sitems.organization_id = l_organization_id
4008: AND sitems.inventory_item_id = p_line_rec.inventory_item_id

Line 4023: ,mtl_system_items_vl sitems

4019: ,x_line_val_rec.ordered_item_dsp
4020: ,x_line_val_rec.inventory_item
4021: FROM mtl_cross_reference_types types
4022: ,mtl_cross_references items
4023: ,mtl_system_items_vl sitems
4024: WHERE types.cross_reference_type = items.cross_reference_type
4025: AND items.inventory_item_id = sitems.inventory_item_id
4026: AND sitems.organization_id = l_organization_id
4027: AND sitems.inventory_item_id = p_line_rec.inventory_item_id

Line 4040: FROM mtl_system_items_vl

4036: ,concatenated_segments
4037: INTO x_line_val_rec.item_description
4038: ,x_line_val_rec.ordered_item_dsp
4039: ,x_line_val_rec.inventory_item
4040: FROM mtl_system_items_vl
4041: WHERE inventory_item_id = p_line_rec.inventory_item_id
4042: AND organization_id = l_organization_id;
4043: END IF ;
4044: When Others then

Line 5090: FROM mtl_system_items_vl

5086: oe_debug_pub.add( 'ENTERING INT::EXACT MATCH' ) ;
5087: END IF;
5088: SELECT count(*)
5089: INTO l_count
5090: FROM mtl_system_items_vl
5091: WHERE inventory_item_id = p_inventory_item_id
5092: AND organization_id = l_organization_id
5093: AND description = p_description;
5094: ELSE

Line 5117: ,mtl_system_items_vl sitems

5113: SELECT count(*)
5114: INTO l_count
5115: FROM mtl_customer_items citems
5116: ,mtl_customer_item_xrefs cxref
5117: ,mtl_system_items_vl sitems
5118: WHERE citems.customer_item_id = cxref.customer_item_id
5119: AND cxref.inventory_item_id = sitems.inventory_item_id
5120: AND sitems.inventory_item_id = p_inventory_item_id
5121: AND sitems.organization_id = l_organization_id

Line 5133: ,mtl_system_items_vl sitems

5129: SELECT count(*)
5130: INTO l_count
5131: FROM mtl_customer_items citems
5132: ,mtl_customer_item_xrefs cxref
5133: ,mtl_system_items_vl sitems
5134: WHERE citems.customer_item_id = cxref.customer_item_id
5135: AND cxref.inventory_item_id = sitems.inventory_item_id
5136: AND sitems.inventory_item_id = p_inventory_item_id
5137: AND sitems.organization_id = l_organization_id

Line 5152: , mtl_system_items_vl sitems

5148: SELECT count(*)
5149: INTO l_count
5150: FROM mtl_cross_reference_types types
5151: , mtl_cross_references items
5152: , mtl_system_items_vl sitems
5153: WHERE types.cross_reference_type = items.cross_reference_type
5154: AND items.inventory_item_id = sitems.inventory_item_id
5155: AND sitems.inventory_item_id = p_inventory_item_id
5156: AND sitems.organization_id = l_organization_id

Line 5168: , mtl_system_items_vl sitems

5164: SELECT count(*)
5165: INTO l_count
5166: FROM mtl_cross_reference_types types
5167: , mtl_cross_references items
5168: , mtl_system_items_vl sitems
5169: WHERE types.cross_reference_type = items.cross_reference_type
5170: AND items.inventory_item_id = sitems.inventory_item_id
5171: AND sitems.inventory_item_id = p_inventory_item_id
5172: AND sitems.organization_id = l_organization_id

Line 5230: FROM mtl_system_items_vl

5226: oe_debug_pub.add( 'ENTERING INT::EXACT MATCH' ) ;
5227: END IF;
5228: SELECT count(*)
5229: INTO l_count
5230: FROM mtl_system_items_vl
5231: WHERE inventory_item_id = p_inventory_item_id
5232: AND organization_id = l_organization_id
5233: AND concatenated_segments = p_inventory_item;
5234: ELSE

Line 5240: FROM mtl_system_items_vl

5236: oe_debug_pub.add( 'ENTERING INT::PARTIAL' ) ;
5237: END IF;
5238: SELECT count(*)
5239: INTO l_count
5240: FROM mtl_system_items_vl
5241: WHERE inventory_item_id = p_inventory_item_id
5242: AND organization_id = l_organization_id
5243: AND concatenated_segments like p_inventory_item;
5244: END IF;

Line 5255: ,mtl_system_items_vl sitems

5251: SELECT count(*)
5252: INTO l_count
5253: FROM mtl_customer_items citems
5254: ,mtl_customer_item_xrefs cxref
5255: ,mtl_system_items_vl sitems
5256: WHERE citems.customer_item_id = cxref.customer_item_id
5257: AND cxref.inventory_item_id = sitems.inventory_item_id
5258: AND sitems.inventory_item_id = p_inventory_item_id
5259: AND sitems.organization_id = l_organization_id

Line 5271: ,mtl_system_items_vl sitems

5267: SELECT count(*)
5268: INTO l_count
5269: FROM mtl_customer_items citems
5270: ,mtl_customer_item_xrefs cxref
5271: ,mtl_system_items_vl sitems
5272: WHERE citems.customer_item_id = cxref.customer_item_id
5273: AND cxref.inventory_item_id = sitems.inventory_item_id
5274: AND sitems.inventory_item_id = p_inventory_item_id
5275: AND sitems.organization_id = l_organization_id

Line 5291: , mtl_system_items_vl sitems

5287: SELECT count(*)
5288: INTO l_count
5289: FROM mtl_cross_reference_types types
5290: , mtl_cross_references items
5291: , mtl_system_items_vl sitems
5292: WHERE types.cross_reference_type = items.cross_reference_type
5293: AND items.inventory_item_id = sitems.inventory_item_id
5294: AND sitems.inventory_item_id = p_inventory_item_id
5295: AND sitems.organization_id = l_organization_id

Line 5307: , mtl_system_items_vl sitems

5303: SELECT count(*)
5304: INTO l_count
5305: FROM mtl_cross_reference_types types
5306: , mtl_cross_references items
5307: , mtl_system_items_vl sitems
5308: WHERE types.cross_reference_type = items.cross_reference_type
5309: AND items.inventory_item_id = sitems.inventory_item_id
5310: AND sitems.inventory_item_id = p_inventory_item_id
5311: AND sitems.organization_id = l_organization_id

Line 5367: FROM mtl_system_items_vl

5363: oe_debug_pub.add( 'ENTERING INT::EXACT MATCH' ) ;
5364: END IF;
5365: SELECT count(*)
5366: INTO l_count
5367: FROM mtl_system_items_vl
5368: WHERE inventory_item_id = p_inventory_item_id
5369: AND organization_id = l_organization_id
5370: AND concatenated_segments = p_item;
5371: ELSE

Line 5377: FROM mtl_system_items_vl

5373: oe_debug_pub.add( 'ENTERING INT::PARTIAL' ) ;
5374: END IF;
5375: SELECT count(*)
5376: INTO l_count
5377: FROM mtl_system_items_vl
5378: WHERE inventory_item_id = p_inventory_item_id
5379: AND organization_id = l_organization_id
5380: AND concatenated_segments like p_item;
5381: END IF;

Line 5392: ,mtl_system_items_vl sitems

5388: SELECT count(*)
5389: INTO l_count
5390: FROM mtl_customer_items citems
5391: ,mtl_customer_item_xrefs cxref
5392: ,mtl_system_items_vl sitems
5393: WHERE citems.customer_item_id = cxref.customer_item_id
5394: AND cxref.inventory_item_id = sitems.inventory_item_id
5395: AND sitems.inventory_item_id = p_inventory_item_id
5396: AND sitems.organization_id = l_organization_id

Line 5408: ,mtl_system_items_vl sitems

5404: SELECT count(*)
5405: INTO l_count
5406: FROM mtl_customer_items citems
5407: ,mtl_customer_item_xrefs cxref
5408: ,mtl_system_items_vl sitems
5409: WHERE citems.customer_item_id = cxref.customer_item_id
5410: AND cxref.inventory_item_id = sitems.inventory_item_id
5411: AND sitems.inventory_item_id = p_inventory_item_id
5412: AND sitems.organization_id = l_organization_id

Line 5427: , mtl_system_items_vl sitems

5423: SELECT count(*)
5424: INTO l_count
5425: FROM mtl_cross_reference_types types
5426: , mtl_cross_references items
5427: , mtl_system_items_vl sitems
5428: WHERE types.cross_reference_type = items.cross_reference_type
5429: AND items.inventory_item_id = sitems.inventory_item_id
5430: AND sitems.inventory_item_id = p_inventory_item_id
5431: AND sitems.organization_id = l_organization_id

Line 5443: , mtl_system_items_vl sitems

5439: SELECT count(*)
5440: INTO l_count
5441: FROM mtl_cross_reference_types types
5442: , mtl_cross_references items
5443: , mtl_system_items_vl sitems
5444: WHERE types.cross_reference_type = items.cross_reference_type
5445: AND items.inventory_item_id = sitems.inventory_item_id
5446: AND sitems.inventory_item_id = p_inventory_item_id
5447: AND sitems.organization_id = l_organization_id

Line 6188: ,mtl_system_items_vl sitems

6184: SELECT citems.customer_item_number
6185: INTO x_ordered_item
6186: FROM mtl_customer_items citems
6187: ,mtl_customer_item_xrefs cxref
6188: ,mtl_system_items_vl sitems
6189: WHERE citems.customer_item_id = cxref.customer_item_id
6190: AND cxref.inventory_item_id = sitems.inventory_item_id
6191: AND sitems.inventory_item_id = p_inventory_item_id
6192: AND sitems.organization_id = l_organization_id