APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_RESERVATIONS

Line 1965: from mtl_reservations mr

1961: AND NVL(revision, '@@@') = NVL(NVL(p_revision, '@@@'), NVL(revision, '@@@'))
1962: AND msn.serial_number LIKE p_serial
1963: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, inv_globals.g_type_container_unpack, NULL, NULL, p_organization_id, msn.inventory_item_id, NULL, NULL, NULL, msn.serial_number, 'S') = 'Y'
1964: AND NOT EXISTS (select 1
1965: from mtl_reservations mr
1966: where mr.reservation_id = msn.reservation_id
1967: and mr.lpn_id = p_lpn_id)
1968: ORDER BY LPAD(msn.serial_number, 20);
1969: END get_cont_serial_lov;

Line 2000: from mtl_reservations mr

1996: AND NVL(revision, '@') = NVL(NVL(p_revision, '@'), NVL(revision, '@'))
1997: AND msn.serial_number LIKE (p_serial)
1998: AND (inv_material_status_grp.is_status_applicable('TRUE', NULL, inv_globals.g_type_container_split, NULL, NULL, p_organization_id, msn.inventory_item_id, NULL, NULL, NULL, msn.serial_number, 'S') = 'Y')
1999: AND NOT EXISTS (select 1
2000: from mtl_reservations mr
2001: where mr.reservation_id = msn.reservation_id
2002: and mr.lpn_id = p_lpn_id)
2003: ORDER BY LPAD(msn.serial_number, 20);
2004: ELSE -- Outbound or Salesorder ( p_transaction_subtype in (2, 3) )

Line 2819: FROM mtl_reservations mr

2815: OR ( msn.group_mark_id IS NOT NULL
2816: -- Performance Bug : 5367744
2817: AND NOT EXISTS (
2818: SELECT 1
2819: FROM mtl_reservations mr
2820: WHERE mr.reservation_id = msn.reservation_id
2821: AND NVL(mr.staged_flag, 'N') = 'Y')
2822: AND NOT EXISTS (
2823: SELECT 1