DBA Data[Home] [Help]

APPS.BOMPVALB dependencies on MTL_ITEM_LOCATIONS

Line 1806: from mtl_item_locations

1802: if (r_loc = 2) then /* non-restricted locator */
1803: begin
1804: select 'loc exists'
1805: into dummy
1806: from mtl_item_locations
1807: where inventory_location_id = c1rec.SLI
1808: and organization_id = c1rec.OI
1809: and subinventory_code = c1rec.SS
1810: and nvl(disable_date,trunc(c1rec.EDD)+1) > trunc(c1rec.EDD);

Line 1819: from mtl_item_locations loc,

1815: else /* restricted locator */
1816: begin
1817: select 'restricted loc exists'
1818: into dummy
1819: from mtl_item_locations loc,
1820: mtl_secondary_locators item
1821: where loc.inventory_location_id = c1rec.SLI
1822: and loc.organization_id = c1rec.OI
1823: and loc.subinventory_code = c1rec.SS

Line 1857: from mtl_item_locations

1853: if (r_loc = 2) then /* non-restricted locator */
1854: begin
1855: select 'loc exists'
1856: into dummy
1857: from mtl_item_locations
1858: where inventory_location_id = c1rec.SLI
1859: and organization_id = c1rec.OI
1860: and subinventory_code = c1rec.SS
1861: and nvl(disable_date,trunc(c1rec.EDD)+1) >

Line 1871: from mtl_item_locations loc,

1867: else /* restricted locator */
1868: begin
1869: select 'restricted loc exists'
1870: into dummy
1871: from mtl_item_locations loc,
1872: mtl_secondary_locators item
1873: where loc.inventory_location_id = c1rec.SLI
1874: and loc.organization_id = c1rec.OI
1875: and loc.subinventory_code = c1rec.SS

Line 1911: from mtl_item_locations

1907: if (r_loc = 2) then /* non-restricted locator */
1908: begin
1909: select 'loc exists'
1910: into dummy
1911: from mtl_item_locations
1912: where inventory_location_id = c1rec.SLI
1913: and organization_id = c1rec.OI
1914: and subinventory_code = c1rec.SS
1915: and nvl(disable_date,trunc(c1rec.EDD)+1) >

Line 1925: from mtl_item_locations loc,

1921: else /* restricted locator */
1922: begin
1923: select 'restricted loc exists'
1924: into dummy
1925: from mtl_item_locations loc,
1926: mtl_secondary_locators item
1927: where loc.inventory_location_id = c1rec.SLI
1928: and loc.organization_id = c1rec.OI
1929: and loc.subinventory_code = c1rec.SS