APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_RESERVATIONS

Line 1894: from mtl_reservations mr

1890: AND NVL(revision, '@@@') = NVL(NVL(p_revision, '@@@'), NVL(revision, '@@@'))
1891: AND msn.serial_number LIKE p_serial
1892: 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'
1893: AND NOT EXISTS (select 1
1894: from mtl_reservations mr
1895: where mr.reservation_id = msn.reservation_id
1896: and mr.lpn_id = p_lpn_id)
1897: ORDER BY LPAD(msn.serial_number, 20);
1898: END get_cont_serial_lov;

Line 1921: from mtl_reservations mr

1917: AND NVL(revision, '@') = NVL(NVL(p_revision, '@'), NVL(revision, '@'))
1918: AND msn.serial_number LIKE (p_serial)
1919: 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')
1920: AND NOT EXISTS (select 1
1921: from mtl_reservations mr
1922: where mr.reservation_id = msn.reservation_id
1923: and mr.lpn_id = p_lpn_id)
1924: ORDER BY LPAD(msn.serial_number, 20);
1925: ELSE -- Outbound or Salesorder ( p_transaction_subtype in (2, 3) )

Line 2732: FROM mtl_reservations mr

2728: OR ( msn.group_mark_id IS NOT NULL
2729: -- Performance Bug : 5367744
2730: AND NOT EXISTS (
2731: SELECT 1
2732: FROM mtl_reservations mr
2733: WHERE mr.reservation_id = msn.reservation_id
2734: AND NVL(mr.staged_flag, 'N') = 'Y')
2735: AND NOT EXISTS (
2736: SELECT 1