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 4013: ,mtl_customer_item_xrefs cxref

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
4017: AND cxref.inventory_item_id = sitems.inventory_item_id

Line 5398: ,mtl_customer_item_xrefs cxref

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
5402: AND sitems.inventory_item_id = p_inventory_item_id

Line 5414: ,mtl_customer_item_xrefs cxref

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
5418: AND sitems.inventory_item_id = p_inventory_item_id

Line 5539: ,mtl_customer_item_xrefs cxref

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
5543: AND sitems.inventory_item_id = p_inventory_item_id

Line 5555: ,mtl_customer_item_xrefs cxref

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
5559: AND sitems.inventory_item_id = p_inventory_item_id

Line 5679: ,mtl_customer_item_xrefs cxref

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
5683: AND sitems.inventory_item_id = p_inventory_item_id

Line 5695: ,mtl_customer_item_xrefs cxref

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
5699: AND sitems.inventory_item_id = p_inventory_item_id

Line 6579: ,mtl_customer_item_xrefs cxref

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
6583: AND sitems.inventory_item_id = p_inventory_item_id