DBA Data[Home] [Help]

APPS.MRP_MRPRPROP_XMLP_PKG dependencies on MTL_LOT_NUMBERS

Line 1497: MTL_LOT_NUMBERS MLN

1493: OR EXISTS (
1494: SELECT
1495: 1
1496: FROM
1497: MTL_LOT_NUMBERS MLN
1498: WHERE MLN.ORGANIZATION_ID = ORG_ID
1499: AND MLN.LOT_NUMBER = LOT_NUMBER
1500: AND MLN.INVENTORY_ITEM_ID = ITEM_ID
1501: AND MLN.AVAILABILITY_TYPE = DECODE(INCLUDE_NONNET

Line 1616: MTL_LOT_NUMBERS MLN

1612: OR EXISTS (
1613: SELECT
1614: 1
1615: FROM
1616: MTL_LOT_NUMBERS MLN
1617: WHERE MLN.ORGANIZATION_ID = ORG_ID
1618: AND MLN.LOT_NUMBER = MTR.LOT_NUMBER
1619: AND MLN.INVENTORY_ITEM_ID = ITEM_ID
1620: AND MLN.AVAILABILITY_TYPE = DECODE(INCLUDE_NONNET

Line 1712: MTL_LOT_NUMBERS MLN

1708: OR EXISTS (
1709: SELECT
1710: 1
1711: FROM
1712: MTL_LOT_NUMBERS MLN
1713: WHERE MLN.ORGANIZATION_ID = ORG_ID
1714: AND MLN.LOT_NUMBER = MTRL.LOT_NUMBER
1715: AND MLN.INVENTORY_ITEM_ID = ITEM_ID
1716: AND MLN.AVAILABILITY_TYPE = DECODE(INCLUDE_NONNET