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.POS_EXCELASN_PVT dependencies on MTL_SYSTEM_ITEMS

Line 3534: select /+ INDEX (msi, mtl_system_items_b_u1) /

3530: BEGIN
3531: update pos_exasn_lines plnt
3532: set plnt.lls_Code = 'LAS'
3533: where exists(
3534: select /*+ INDEX (msi, mtl_system_items_b_u1) */
3535: 1 from mtl_system_items msi
3536: where msi.inventory_item_id = plnt.item_id
3537: and msi.organization_id = plnt.org_id
3538: and msi.lot_control_code = 2

Line 3535: 1 from mtl_system_items msi

3531: update pos_exasn_lines plnt
3532: set plnt.lls_Code = 'LAS'
3533: where exists(
3534: select /*+ INDEX (msi, mtl_system_items_b_u1) */
3535: 1 from mtl_system_items msi
3536: where msi.inventory_item_id = plnt.item_id
3537: and msi.organization_id = plnt.org_id
3538: and msi.lot_control_code = 2
3539: and msi.serial_number_control_code in (2,5));

Line 3545: select /+ INDEX (msi, mtl_system_items_b_u1) /

3541: update pos_exasn_lines plnt
3542: set plnt.lls_Code = 'LOT'
3543: where plnt.lls_code is null
3544: and exists(
3545: select /*+ INDEX (msi, mtl_system_items_b_u1) */
3546: 1 from mtl_system_items msi
3547: where msi.inventory_item_id = plnt.item_id
3548: and msi.organization_id = plnt.org_id
3549: and msi.lot_control_code = 2

Line 3546: 1 from mtl_system_items msi

3542: set plnt.lls_Code = 'LOT'
3543: where plnt.lls_code is null
3544: and exists(
3545: select /*+ INDEX (msi, mtl_system_items_b_u1) */
3546: 1 from mtl_system_items msi
3547: where msi.inventory_item_id = plnt.item_id
3548: and msi.organization_id = plnt.org_id
3549: and msi.lot_control_code = 2
3550: and msi.serial_number_control_code not in (2,5));

Line 3556: select /+ INDEX (msi, mtl_system_items_b_u1) /

3552: update pos_exasn_lines plnt
3553: set plnt.lls_Code = 'SER'
3554: where plnt.lls_code is null
3555: and exists(
3556: select /*+ INDEX (msi, mtl_system_items_b_u1) */
3557: 1 from mtl_system_items msi
3558: where msi.inventory_item_id = plnt.item_id
3559: and msi.organization_id = plnt.org_id
3560: and msi.lot_control_code = 1

Line 3557: 1 from mtl_system_items msi

3553: set plnt.lls_Code = 'SER'
3554: where plnt.lls_code is null
3555: and exists(
3556: select /*+ INDEX (msi, mtl_system_items_b_u1) */
3557: 1 from mtl_system_items msi
3558: where msi.inventory_item_id = plnt.item_id
3559: and msi.organization_id = plnt.org_id
3560: and msi.lot_control_code = 1
3561: and msi.serial_number_control_code in (2,5));