APPS.WMS_RULE_10 dependencies on MTL_SECONDARY_INVENTORIES

Line 154: ,MTL_SECONDARY_INVENTORIES msei

150: ,mil.SUGGESTED_WEIGHT
151: ,mil.LOCATION_SUGGESTED_UNITS
152: ,mil.rowid
153: from MTL_ITEM_LOCATIONS mil
154: ,MTL_SECONDARY_INVENTORIES msei
155: where mil.organization_id(+) = msei.organization_id
156: and mil.subinventory_code(+) = msei.secondary_inventory_name
157: and NVL(msei.disable_date, sysdate+1) > sysdate
158: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 283: ,MTL_SECONDARY_INVENTORIES msei

279: ,mil.SUGGESTED_WEIGHT
280: ,mil.LOCATION_SUGGESTED_UNITS
281: ,mil.rowid
282: from MTL_ITEM_LOCATIONS mil
283: ,MTL_SECONDARY_INVENTORIES msei
284: where mil.organization_id(+) = msei.organization_id
285: and mil.subinventory_code(+) = msei.secondary_inventory_name
286: and NVL(msei.disable_date, sysdate+1) > sysdate
287: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 411: ,MTL_SECONDARY_INVENTORIES msei

407: ,mil.SUGGESTED_WEIGHT
408: ,mil.LOCATION_SUGGESTED_UNITS
409: ,mil.rowid
410: from MTL_ITEM_LOCATIONS mil
411: ,MTL_SECONDARY_INVENTORIES msei
412: where mil.organization_id(+) = msei.organization_id
413: and mil.subinventory_code(+) = msei.secondary_inventory_name
414: and NVL(msei.disable_date, sysdate+1) > sysdate
415: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 541: ,MTL_SECONDARY_INVENTORIES msei

537: ,mil.SUGGESTED_WEIGHT
538: ,mil.LOCATION_SUGGESTED_UNITS
539: ,mil.rowid
540: from MTL_ITEM_LOCATIONS mil
541: ,MTL_SECONDARY_INVENTORIES msei
542: ,MTL_ITEM_SUB_INVENTORIES misi
543: where mil.organization_id(+) = msei.organization_id
544: and mil.organization_id=g_organization_id ---bug8425620 8665549
545: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 671: ,MTL_SECONDARY_INVENTORIES msei

667: ,mil.SUGGESTED_WEIGHT
668: ,mil.LOCATION_SUGGESTED_UNITS
669: ,mil.rowid
670: from MTL_ITEM_LOCATIONS mil
671: ,MTL_SECONDARY_INVENTORIES msei
672: ,MTL_ITEM_SUB_INVENTORIES misi
673: where mil.organization_id(+) = msei.organization_id
674: and mil.organization_id=g_organization_id ---bug8425620 8665549
675: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 803: ,MTL_SECONDARY_INVENTORIES msei

799: ,mil.SUGGESTED_WEIGHT
800: ,mil.LOCATION_SUGGESTED_UNITS
801: ,mil.rowid
802: from MTL_ITEM_LOCATIONS mil
803: ,MTL_SECONDARY_INVENTORIES msei
804: ,MTL_ITEM_SUB_INVENTORIES misi
805: where mil.organization_id(+) = msei.organization_id
806: and mil.organization_id=g_organization_id ---bug8425620 8665549
807: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 937: ,MTL_SECONDARY_INVENTORIES msei

933: ,mil.SUGGESTED_WEIGHT
934: ,mil.LOCATION_SUGGESTED_UNITS
935: ,mil.rowid
936: from MTL_ITEM_LOCATIONS mil
937: ,MTL_SECONDARY_INVENTORIES msei
938: ,MTL_ITEM_SUB_INVENTORIES misi
939: ,MTL_SECONDARY_LOCATORS msl
940: where mil.organization_id = msei.organization_id
941: and mil.organization_id=g_organization_id ---bug8425620 8665549

Line 1072: ,MTL_SECONDARY_INVENTORIES msei

1068: ,mil.SUGGESTED_WEIGHT
1069: ,mil.LOCATION_SUGGESTED_UNITS
1070: ,mil.rowid
1071: from MTL_ITEM_LOCATIONS mil
1072: ,MTL_SECONDARY_INVENTORIES msei
1073: ,MTL_ITEM_SUB_INVENTORIES misi
1074: ,MTL_SECONDARY_LOCATORS msl
1075: where mil.organization_id = msei.organization_id
1076: and mil.organization_id=g_organization_id ---bug8425620 8665549

Line 1208: ,MTL_SECONDARY_INVENTORIES msei

1204: ,mil.SUGGESTED_WEIGHT
1205: ,mil.LOCATION_SUGGESTED_UNITS
1206: ,mil.rowid
1207: from MTL_ITEM_LOCATIONS mil
1208: ,MTL_SECONDARY_INVENTORIES msei
1209: ,MTL_ITEM_SUB_INVENTORIES misi
1210: ,MTL_SECONDARY_LOCATORS msl
1211: where mil.organization_id = msei.organization_id
1212: and mil.organization_id=g_organization_id ---bug8425620 8665549