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 4012: FROM mtl_customer_items citems

4008: --,sitems.concatenated_segments /*Bug 1766327 chhung*/
4009: INTO x_line_val_rec.item_description
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

Line 5397: FROM mtl_customer_items citems

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

Line 5413: FROM mtl_customer_items citems

5409: oe_debug_pub.add( 'ENTERING CUST::PARTIAL' ) ;
5410: END IF;
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

Line 5538: FROM mtl_customer_items citems

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

Line 5554: FROM mtl_customer_items citems

5550: oe_debug_pub.add( 'ENTERING CUST::PARTIAL' ) ;
5551: END IF;
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

Line 5678: FROM mtl_customer_items citems

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

Line 5694: FROM mtl_customer_items citems

5690: oe_debug_pub.add( 'ENTERING CUST::PARTIAL' ) ;
5691: END IF;
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

Line 6578: FROM mtl_customer_items citems

6574: 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
6575: BEGIN
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