APPS.WMS_RULE_9 dependencies on MTL_SECONDARY_INVENTORIES

Line 156: ,MTL_SECONDARY_INVENTORIES msei

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

Line 318: ,MTL_SECONDARY_INVENTORIES msei

314: ,mil.SUGGESTED_WEIGHT
315: ,mil.LOCATION_SUGGESTED_UNITS
316: ,mil.rowid
317: from MTL_ITEM_LOCATIONS mil
318: ,MTL_SECONDARY_INVENTORIES msei
319: where mil.organization_id(+) = msei.organization_id
320: and mil.subinventory_code(+) = msei.secondary_inventory_name
321: and NVL(msei.disable_date, sysdate+1) > sysdate
322: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 479: ,MTL_SECONDARY_INVENTORIES msei

475: ,mil.SUGGESTED_WEIGHT
476: ,mil.LOCATION_SUGGESTED_UNITS
477: ,mil.rowid
478: from MTL_ITEM_LOCATIONS mil
479: ,MTL_SECONDARY_INVENTORIES msei
480: where mil.organization_id(+) = msei.organization_id
481: and mil.subinventory_code(+) = msei.secondary_inventory_name
482: and NVL(msei.disable_date, sysdate+1) > sysdate
483: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 642: ,MTL_SECONDARY_INVENTORIES msei

638: ,mil.SUGGESTED_WEIGHT
639: ,mil.LOCATION_SUGGESTED_UNITS
640: ,mil.rowid
641: from MTL_ITEM_LOCATIONS mil
642: ,MTL_SECONDARY_INVENTORIES msei
643: ,MTL_ITEM_SUB_INVENTORIES misi
644: where mil.organization_id(+) = msei.organization_id
645: and mil.organization_id=g_organization_id ---bug8425620 8665549
646: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 805: ,MTL_SECONDARY_INVENTORIES msei

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

Line 970: ,MTL_SECONDARY_INVENTORIES msei

966: ,mil.SUGGESTED_WEIGHT
967: ,mil.LOCATION_SUGGESTED_UNITS
968: ,mil.rowid
969: from MTL_ITEM_LOCATIONS mil
970: ,MTL_SECONDARY_INVENTORIES msei
971: ,MTL_ITEM_SUB_INVENTORIES misi
972: where mil.organization_id(+) = msei.organization_id
973: and mil.organization_id=g_organization_id ---bug8425620 8665549
974: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 1137: ,MTL_SECONDARY_INVENTORIES msei

1133: ,mil.SUGGESTED_WEIGHT
1134: ,mil.LOCATION_SUGGESTED_UNITS
1135: ,mil.rowid
1136: from MTL_ITEM_LOCATIONS mil
1137: ,MTL_SECONDARY_INVENTORIES msei
1138: ,MTL_ITEM_SUB_INVENTORIES misi
1139: ,MTL_SECONDARY_LOCATORS msl
1140: where mil.organization_id = msei.organization_id
1141: and mil.organization_id=g_organization_id ---bug8425620 8665549

Line 1305: ,MTL_SECONDARY_INVENTORIES msei

1301: ,mil.SUGGESTED_WEIGHT
1302: ,mil.LOCATION_SUGGESTED_UNITS
1303: ,mil.rowid
1304: from MTL_ITEM_LOCATIONS mil
1305: ,MTL_SECONDARY_INVENTORIES msei
1306: ,MTL_ITEM_SUB_INVENTORIES misi
1307: ,MTL_SECONDARY_LOCATORS msl
1308: where mil.organization_id = msei.organization_id
1309: and mil.organization_id=g_organization_id ---bug8425620 8665549

Line 1474: ,MTL_SECONDARY_INVENTORIES msei

1470: ,mil.SUGGESTED_WEIGHT
1471: ,mil.LOCATION_SUGGESTED_UNITS
1472: ,mil.rowid
1473: from MTL_ITEM_LOCATIONS mil
1474: ,MTL_SECONDARY_INVENTORIES msei
1475: ,MTL_ITEM_SUB_INVENTORIES misi
1476: ,MTL_SECONDARY_LOCATORS msl
1477: where mil.organization_id = msei.organization_id
1478: and mil.organization_id=g_organization_id ---bug8425620 8665549