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 3961: FROM mtl_system_items_vl

3957: --,concatenated_segments /*Bug 1766327 chhung*/
3958: INTO x_line_val_rec.item_description
3959: --,x_line_val_rec.ordered_item_dsp
3960: --,x_line_val_rec.inventory_item /*bug 1766327 chhung*/
3961: FROM mtl_system_items_vl
3962: WHERE inventory_item_id = p_line_rec.inventory_item_id
3963: AND organization_id = l_organization_id;
3964:
3965: --bug 10047225

Line 4014: ,mtl_system_items_vl sitems

4010: ,x_line_val_rec.ordered_item_dsp
4011: --,x_line_val_rec.inventory_item /*Bug 1766327 chhung*/
4012: FROM mtl_customer_items citems
4013: ,mtl_customer_item_xrefs cxref
4014: ,mtl_system_items_vl sitems
4015: ,mtl_parameters mp -- bug 3918771
4016: WHERE citems.customer_item_id = cxref.customer_item_id
4017: AND cxref.inventory_item_id = sitems.inventory_item_id
4018: AND sitems.inventory_item_id = p_line_rec.inventory_item_id

Line 4065: FROM mtl_system_items_vl

4061: --,concatenated_segments
4062: INTO x_line_val_rec.item_description
4063: ,x_line_val_rec.ordered_item_dsp
4064: --,x_line_val_rec.inventory_item
4065: FROM mtl_system_items_vl
4066: WHERE inventory_item_id = p_line_rec.inventory_item_id
4067: AND organization_id = l_organization_id;
4068:
4069: --bug 10047225

Line 4120: , mtl_system_items_vl sitems

4116: ,x_line_val_rec.ordered_item_dsp
4117: --,x_line_val_rec.inventory_item /*Bug 1766327 chhung*/
4118: FROM mtl_cross_reference_types types
4119: , mtl_cross_references items
4120: , mtl_system_items_vl sitems
4121: WHERE types.cross_reference_type = items.cross_reference_type
4122: AND items.inventory_item_id = sitems.inventory_item_id
4123: AND sitems.organization_id = l_organization_id
4124: AND sitems.inventory_item_id = p_line_rec.inventory_item_id

Line 4168: FROM mtl_system_items_vl

4164: --,concatenated_segments
4165: INTO x_line_val_rec.item_description
4166: ,x_line_val_rec.ordered_item_dsp
4167: --,x_line_val_rec.inventory_item
4168: FROM mtl_system_items_vl
4169: WHERE inventory_item_id = p_line_rec.inventory_item_id
4170: AND organization_id = l_organization_id;
4171:
4172: --bug 10047225

Line 4211: ,mtl_system_items_vl sitems

4207: ,x_line_val_rec.ordered_item_dsp
4208: --,x_line_val_rec.inventory_item
4209: FROM mtl_cross_reference_types types
4210: ,mtl_cross_references items
4211: ,mtl_system_items_vl sitems
4212: WHERE types.cross_reference_type = items.cross_reference_type
4213: AND items.inventory_item_id = sitems.inventory_item_id
4214: AND sitems.organization_id = l_organization_id
4215: AND sitems.inventory_item_id = p_line_rec.inventory_item_id

Line 4251: ,mtl_system_items_vl sitems

4247: ,x_line_val_rec.ordered_item_dsp
4248: --,x_line_val_rec.inventory_item
4249: FROM mtl_cross_reference_types types
4250: ,mtl_cross_references items
4251: ,mtl_system_items_vl sitems
4252: WHERE types.cross_reference_type = items.cross_reference_type
4253: AND items.inventory_item_id = sitems.inventory_item_id
4254: AND sitems.organization_id = l_organization_id
4255: AND sitems.inventory_item_id = p_line_rec.inventory_item_id

Line 4289: FROM mtl_system_items_vl

4285: --,concatenated_segments
4286: INTO x_line_val_rec.item_description
4287: ,x_line_val_rec.ordered_item_dsp
4288: --,x_line_val_rec.inventory_item
4289: FROM mtl_system_items_vl
4290: WHERE inventory_item_id = p_line_rec.inventory_item_id
4291: AND organization_id = l_organization_id;
4292: --bug 10047225
4293: l_valid_kff:= fnd_flex_keyval.validate_ccid(

Line 5372: FROM mtl_system_items_vl

5368: oe_debug_pub.add( 'ENTERING INT::EXACT MATCH' ) ;
5369: END IF;
5370: SELECT count(*)
5371: INTO l_count
5372: FROM mtl_system_items_vl
5373: WHERE inventory_item_id = p_inventory_item_id
5374: AND organization_id = l_organization_id
5375: AND description = p_description;
5376: ELSE

Line 5399: ,mtl_system_items_vl sitems

5395: SELECT count(*)
5396: INTO l_count
5397: FROM mtl_customer_items citems
5398: ,mtl_customer_item_xrefs cxref
5399: ,mtl_system_items_vl sitems
5400: WHERE citems.customer_item_id = cxref.customer_item_id
5401: AND cxref.inventory_item_id = sitems.inventory_item_id
5402: AND sitems.inventory_item_id = p_inventory_item_id
5403: AND sitems.organization_id = l_organization_id

Line 5415: ,mtl_system_items_vl sitems

5411: SELECT count(*)
5412: INTO l_count
5413: FROM mtl_customer_items citems
5414: ,mtl_customer_item_xrefs cxref
5415: ,mtl_system_items_vl sitems
5416: WHERE citems.customer_item_id = cxref.customer_item_id
5417: AND cxref.inventory_item_id = sitems.inventory_item_id
5418: AND sitems.inventory_item_id = p_inventory_item_id
5419: AND sitems.organization_id = l_organization_id

Line 5434: , mtl_system_items_vl sitems

5430: SELECT count(*)
5431: INTO l_count
5432: FROM mtl_cross_reference_types types
5433: , mtl_cross_references items
5434: , mtl_system_items_vl sitems
5435: WHERE types.cross_reference_type = items.cross_reference_type
5436: AND items.inventory_item_id = sitems.inventory_item_id
5437: AND sitems.inventory_item_id = p_inventory_item_id
5438: AND sitems.organization_id = l_organization_id

Line 5450: , mtl_system_items_vl sitems

5446: SELECT count(*)
5447: INTO l_count
5448: FROM mtl_cross_reference_types types
5449: , mtl_cross_references items
5450: , mtl_system_items_vl sitems
5451: WHERE types.cross_reference_type = items.cross_reference_type
5452: AND items.inventory_item_id = sitems.inventory_item_id
5453: AND sitems.inventory_item_id = p_inventory_item_id
5454: AND sitems.organization_id = l_organization_id

Line 5515: FROM mtl_system_items_vl

5511: oe_debug_pub.add( 'ENTERING INT::EXACT MATCH' ) ;
5512: END IF;
5513: SELECT count(*)
5514: INTO l_count
5515: FROM mtl_system_items_vl
5516: WHERE inventory_item_id = p_inventory_item_id
5517: AND organization_id = l_organization_id
5518: AND concatenated_segments = p_inventory_item;
5519: ELSE

Line 5525: FROM mtl_system_items_vl

5521: oe_debug_pub.add( 'ENTERING INT::PARTIAL' ) ;
5522: END IF;
5523: SELECT count(*)
5524: INTO l_count
5525: FROM mtl_system_items_vl
5526: WHERE inventory_item_id = p_inventory_item_id
5527: AND organization_id = l_organization_id
5528: AND concatenated_segments like p_inventory_item;
5529: END IF;

Line 5540: ,mtl_system_items_vl sitems

5536: SELECT count(*)
5537: INTO l_count
5538: FROM mtl_customer_items citems
5539: ,mtl_customer_item_xrefs cxref
5540: ,mtl_system_items_vl sitems
5541: WHERE citems.customer_item_id = cxref.customer_item_id
5542: AND cxref.inventory_item_id = sitems.inventory_item_id
5543: AND sitems.inventory_item_id = p_inventory_item_id
5544: AND sitems.organization_id = l_organization_id

Line 5556: ,mtl_system_items_vl sitems

5552: SELECT count(*)
5553: INTO l_count
5554: FROM mtl_customer_items citems
5555: ,mtl_customer_item_xrefs cxref
5556: ,mtl_system_items_vl sitems
5557: WHERE citems.customer_item_id = cxref.customer_item_id
5558: AND cxref.inventory_item_id = sitems.inventory_item_id
5559: AND sitems.inventory_item_id = p_inventory_item_id
5560: AND sitems.organization_id = l_organization_id

Line 5576: , mtl_system_items_vl sitems

5572: SELECT count(*)
5573: INTO l_count
5574: FROM mtl_cross_reference_types types
5575: , mtl_cross_references items
5576: , mtl_system_items_vl sitems
5577: WHERE types.cross_reference_type = items.cross_reference_type
5578: AND items.inventory_item_id = sitems.inventory_item_id
5579: AND sitems.inventory_item_id = p_inventory_item_id
5580: AND sitems.organization_id = l_organization_id

Line 5592: , mtl_system_items_vl sitems

5588: SELECT count(*)
5589: INTO l_count
5590: FROM mtl_cross_reference_types types
5591: , mtl_cross_references items
5592: , mtl_system_items_vl sitems
5593: WHERE types.cross_reference_type = items.cross_reference_type
5594: AND items.inventory_item_id = sitems.inventory_item_id
5595: AND sitems.inventory_item_id = p_inventory_item_id
5596: AND sitems.organization_id = l_organization_id

Line 5655: FROM mtl_system_items_vl

5651: oe_debug_pub.add( 'ENTERING INT::EXACT MATCH' ) ;
5652: END IF;
5653: SELECT count(*)
5654: INTO l_count
5655: FROM mtl_system_items_vl
5656: WHERE inventory_item_id = p_inventory_item_id
5657: AND organization_id = l_organization_id
5658: AND concatenated_segments = p_item;
5659: ELSE

Line 5665: FROM mtl_system_items_vl

5661: oe_debug_pub.add( 'ENTERING INT::PARTIAL' ) ;
5662: END IF;
5663: SELECT count(*)
5664: INTO l_count
5665: FROM mtl_system_items_vl
5666: WHERE inventory_item_id = p_inventory_item_id
5667: AND organization_id = l_organization_id
5668: AND concatenated_segments like p_item;
5669: END IF;

Line 5680: ,mtl_system_items_vl sitems

5676: SELECT count(*)
5677: INTO l_count
5678: FROM mtl_customer_items citems
5679: ,mtl_customer_item_xrefs cxref
5680: ,mtl_system_items_vl sitems
5681: WHERE citems.customer_item_id = cxref.customer_item_id
5682: AND cxref.inventory_item_id = sitems.inventory_item_id
5683: AND sitems.inventory_item_id = p_inventory_item_id
5684: AND sitems.organization_id = l_organization_id

Line 5696: ,mtl_system_items_vl sitems

5692: SELECT count(*)
5693: INTO l_count
5694: FROM mtl_customer_items citems
5695: ,mtl_customer_item_xrefs cxref
5696: ,mtl_system_items_vl sitems
5697: WHERE citems.customer_item_id = cxref.customer_item_id
5698: AND cxref.inventory_item_id = sitems.inventory_item_id
5699: AND sitems.inventory_item_id = p_inventory_item_id
5700: AND sitems.organization_id = l_organization_id

Line 5715: , mtl_system_items_vl sitems

5711: SELECT count(*)
5712: INTO l_count
5713: FROM mtl_cross_reference_types types
5714: , mtl_cross_references items
5715: , mtl_system_items_vl sitems
5716: WHERE types.cross_reference_type = items.cross_reference_type
5717: AND items.inventory_item_id = sitems.inventory_item_id
5718: AND sitems.inventory_item_id = p_inventory_item_id
5719: AND sitems.organization_id = l_organization_id

Line 5731: , mtl_system_items_vl sitems

5727: SELECT count(*)
5728: INTO l_count
5729: FROM mtl_cross_reference_types types
5730: , mtl_cross_references items
5731: , mtl_system_items_vl sitems
5732: WHERE types.cross_reference_type = items.cross_reference_type
5733: AND items.inventory_item_id = sitems.inventory_item_id
5734: AND sitems.inventory_item_id = p_inventory_item_id
5735: AND sitems.organization_id = l_organization_id

Line 6580: ,mtl_system_items_vl sitems

6576: SELECT citems.customer_item_number
6577: INTO x_ordered_item
6578: FROM mtl_customer_items citems
6579: ,mtl_customer_item_xrefs cxref
6580: ,mtl_system_items_vl sitems
6581: WHERE citems.customer_item_id = cxref.customer_item_id
6582: AND cxref.inventory_item_id = sitems.inventory_item_id
6583: AND sitems.inventory_item_id = p_inventory_item_id
6584: AND sitems.organization_id = l_organization_id