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_ITEMS

Line 3890: FROM mtl_customer_items citems

3886: ,sitems.concatenated_segments /*Bug 1766327 chhung*/
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

Line 5115: FROM mtl_customer_items citems

5111: oe_debug_pub.add( 'ENTERING CUST::EXACT MATCH' ) ;
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

Line 5131: FROM mtl_customer_items citems

5127: oe_debug_pub.add( 'ENTERING CUST::PARTIAL' ) ;
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

Line 5253: FROM mtl_customer_items citems

5249: oe_debug_pub.add( 'ENTERING CUST::EXACT MATCH' ) ;
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

Line 5269: FROM mtl_customer_items citems

5265: oe_debug_pub.add( 'ENTERING CUST::PARTIAL' ) ;
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

Line 5390: FROM mtl_customer_items citems

5386: oe_debug_pub.add( 'ENTERING CUST::EXACT MATCH' ) ;
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

Line 5406: FROM mtl_customer_items citems

5402: oe_debug_pub.add( 'ENTERING CUST::PARTIAL' ) ;
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

Line 6186: FROM mtl_customer_items citems

6182: ELSIF NVL(p_item_identifier_type, 'INT') = 'CUST' and p_ordered_item_id is not null and p_sold_to_org_id is not null THEN
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