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_CUSTOMER_ITEM_XREFS

Line 3891: ,mtl_customer_item_xrefs cxref

3887: INTO x_line_val_rec.item_description
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

Line 5116: ,mtl_customer_item_xrefs cxref

5112: END IF;
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

Line 5132: ,mtl_customer_item_xrefs cxref

5128: END IF;
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

Line 5254: ,mtl_customer_item_xrefs cxref

5250: END IF;
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

Line 5270: ,mtl_customer_item_xrefs cxref

5266: END IF;
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

Line 5391: ,mtl_customer_item_xrefs cxref

5387: END IF;
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

Line 5407: ,mtl_customer_item_xrefs cxref

5403: END IF;
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

Line 6187: ,mtl_customer_item_xrefs cxref

6183: BEGIN
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