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.WMS_EPC_PVT dependencies on MTL_CROSS_REFERENCES

Line 313: FROM mtl_cross_references_b

309: --leave it null
310:
311: BEGIN
312: SELECT Nvl(epc_gtin_serial,0) INTO l_cur_serial_num
313: FROM mtl_cross_references_b
314: WHERE CROSS_REFERENCE = To_char(p_gtin)
315: AND cross_reference_type = G_PROFILE_GTIN
316: AND inventory_item_id = p_item_id
317: AND uom_code = p_uom_code

Line 341: UPDATE mtl_cross_references_b

337:
338: --update the table
339: BEGIN
340:
341: UPDATE mtl_cross_references_b
342: SET epc_gtin_serial = l_new_serial
343: WHERE CROSS_REFERENCE = To_char(p_gtin)
344: AND cross_reference_type = G_PROFILE_GTIN
345: AND inventory_item_id = p_item_id

Line 430: FROM mtl_cross_references MCR, mtl_item_revisions_b mirb --USING base TABLE FOR PERFORMANCE

426:
427: BEGIN
428: SELECT 1, To_number(mcr.cross_reference),mirb.revision_id INTO
429: l_found_gtin,l_gtin,l_rev_id
430: FROM mtl_cross_references MCR, mtl_item_revisions_b mirb --USING base TABLE FOR PERFORMANCE
431: WHERE mcr.cross_reference_type = G_PROFILE_GTIN
432: AND mcr.inventory_item_id = p_item_id
433: AND mcr.uom_code = l_mtl_uom.UOM_CODE
434: AND mcr.inventory_item_id = mirb.inventory_item_id

Line 477: FROM mtl_cross_references MCR

473:
474: BEGIN
475: SELECT 1, To_number(mcr.cross_reference) INTO
476: l_found_gtin,l_gtin
477: FROM mtl_cross_references MCR
478: WHERE mcr.cross_reference_type = G_PROFILE_GTIN
479: AND mcr.inventory_item_id = p_item_id
480: AND MCR.revision_id is NULL
481: AND mcr.uom_code = l_mtl_uom.UOM_CODE