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 522: FROM mtl_system_items_b msib

518: FROM mtl_system_items_vl msik /* Bug 5581528 */
519: WHERE msik.organization_id = p_organization_id
520: AND msik.mtl_transactions_enabled_flag = 'Y'
521: AND ((p_transaction_action_id=3 AND EXISTS (SELECT 1
522: FROM mtl_system_items_b msib
523: WHERE msib.inventory_item_id=msik.inventory_item_id
524: AND msib.organization_id = p_to_organization_id
525: AND msib.mtl_transactions_enabled_flag = 'Y'
526: AND (NVL(msik.lot_control_code,1)=2 OR nvl(msib.lot_control_code,1)=1)

Line 530: FROM mtl_system_items_b msib1

526: AND (NVL(msik.lot_control_code,1)=2 OR nvl(msib.lot_control_code,1)=1)
527: AND (NVL(msik.serial_number_control_code,1) IN (2,5) OR nvl(msib.serial_number_control_code,1) IN (1,6))
528: AND (NVL(msik.revision_qty_control_code,1)=2 OR NVL(msib.revision_qty_control_code,1)=1)))
529: OR (p_transaction_action_id<>3 AND EXISTS (SELECT 1
530: FROM mtl_system_items_b msib1
531: WHERE msib1.inventory_item_id=msik.inventory_item_id
532: AND msib1.organization_id=p_to_organization_id
533: AND msib1.mtl_transactions_enabled_flag='Y')))
534: AND msik.concatenated_segments LIKE (p_concatenated_segments||l_append)

Line 586: FROM mtl_system_items_b msib

582: FROM mtl_system_items_vl msik, mtl_cross_references mcr /* Bug 5581528 */
583: WHERE msik.organization_id = p_organization_id
584: AND msik.mtl_transactions_enabled_flag = 'Y'
585: AND ((p_transaction_action_id=3 AND EXISTS (SELECT 1
586: FROM mtl_system_items_b msib
587: WHERE msib.inventory_item_id=msik.inventory_item_id
588: AND msib.organization_id = p_to_organization_id
589: AND msib.mtl_transactions_enabled_flag ='Y'
590: AND (NVL(msik.lot_control_code,1)=2 OR nvl(msib.lot_control_code,1)=1)

Line 594: FROM mtl_system_items_b msib1

590: AND (NVL(msik.lot_control_code,1)=2 OR nvl(msib.lot_control_code,1)=1)
591: AND (NVL(msik.serial_number_control_code,1) IN (2,5) OR nvl(msib.serial_number_control_code,1) IN (1,6))
592: AND (NVL(msik.revision_qty_control_code,1)=2 OR NVL(msib.revision_qty_control_code,1)=1)))
593: OR ((p_transaction_action_id <>3 AND EXISTS(SELECT 1
594: FROM mtl_system_items_b msib1
595: WHERE msib1.inventory_item_id=msik.inventory_item_id
596: AND msib1.organization_id=p_to_organization_id
597: AND msib1.mtl_transactions_enabled_flag='Y'))))
598: AND msik.inventory_item_id = mcr.inventory_item_id