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.INV_UI_ITEM_LOVS dependencies on MTL_SYSTEM_ITEMS_B

Line 476: FROM mtl_system_items_b msib

472: FROM mtl_system_items_vl msik /* Bug 5581528 */
473: WHERE msik.organization_id = p_organization_id
474: AND msik.mtl_transactions_enabled_flag = 'Y'
475: AND ((p_transaction_action_id=3 AND EXISTS (SELECT 1
476: FROM mtl_system_items_b msib
477: WHERE msib.inventory_item_id=msik.inventory_item_id
478: AND msib.organization_id = p_to_organization_id
479: AND msib.mtl_transactions_enabled_flag = 'Y'
480: AND (NVL(msik.lot_control_code,1)=2 OR nvl(msib.lot_control_code,1)=1)

Line 484: FROM mtl_system_items_b msib1

480: AND (NVL(msik.lot_control_code,1)=2 OR nvl(msib.lot_control_code,1)=1)
481: AND (NVL(msik.serial_number_control_code,1) IN (2,5) OR nvl(msib.serial_number_control_code,1) IN (1,6))
482: AND (NVL(msik.revision_qty_control_code,1)=2 OR NVL(msib.revision_qty_control_code,1)=1)))
483: OR (p_transaction_action_id<>3 AND EXISTS (SELECT 1
484: FROM mtl_system_items_b msib1
485: WHERE msib1.inventory_item_id=msik.inventory_item_id
486: AND msib1.organization_id=p_to_organization_id
487: AND msib1.mtl_transactions_enabled_flag='Y')))
488: AND msik.concatenated_segments LIKE (p_concatenated_segments)

Line 539: FROM mtl_system_items_b msib

535: FROM mtl_system_items_vl msik, mtl_cross_references mcr /* Bug 5581528 */
536: WHERE msik.organization_id = p_organization_id
537: AND msik.mtl_transactions_enabled_flag = 'Y'
538: AND ((p_transaction_action_id=3 AND EXISTS (SELECT 1
539: FROM mtl_system_items_b msib
540: WHERE msib.inventory_item_id=msik.inventory_item_id
541: AND msib.organization_id = p_to_organization_id
542: AND msib.mtl_transactions_enabled_flag ='Y'
543: AND (NVL(msik.lot_control_code,1)=2 OR nvl(msib.lot_control_code,1)=1)

Line 547: FROM mtl_system_items_b msib1

543: AND (NVL(msik.lot_control_code,1)=2 OR nvl(msib.lot_control_code,1)=1)
544: AND (NVL(msik.serial_number_control_code,1) IN (2,5) OR nvl(msib.serial_number_control_code,1) IN (1,6))
545: AND (NVL(msik.revision_qty_control_code,1)=2 OR NVL(msib.revision_qty_control_code,1)=1)))
546: OR ((p_transaction_action_id <>3 AND EXISTS(SELECT 1
547: FROM mtl_system_items_b msib1
548: WHERE msib1.inventory_item_id=msik.inventory_item_id
549: AND msib1.organization_id=p_to_organization_id
550: AND msib1.mtl_transactions_enabled_flag='Y'))))
551: AND msik.inventory_item_id = mcr.inventory_item_id