APPS.WMS_RULE_7 dependencies on MTL_ITEM_LOCATIONS

Line 152: from MTL_ITEM_LOCATIONS mil

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

Line 278: from MTL_ITEM_LOCATIONS mil

274: ,mil.SUGGESTED_CUBIC_AREA
275: ,mil.SUGGESTED_WEIGHT
276: ,mil.LOCATION_SUGGESTED_UNITS
277: ,mil.rowid
278: from MTL_ITEM_LOCATIONS mil
279: ,MTL_SECONDARY_INVENTORIES msei
280: where mil.organization_id(+) = msei.organization_id
281: and mil.subinventory_code(+) = msei.secondary_inventory_name
282: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 403: from MTL_ITEM_LOCATIONS mil

399: ,mil.SUGGESTED_CUBIC_AREA
400: ,mil.SUGGESTED_WEIGHT
401: ,mil.LOCATION_SUGGESTED_UNITS
402: ,mil.rowid
403: from MTL_ITEM_LOCATIONS mil
404: ,MTL_SECONDARY_INVENTORIES msei
405: where mil.organization_id(+) = msei.organization_id
406: and mil.subinventory_code(+) = msei.secondary_inventory_name
407: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 530: from MTL_ITEM_LOCATIONS mil

526: ,mil.SUGGESTED_CUBIC_AREA
527: ,mil.SUGGESTED_WEIGHT
528: ,mil.LOCATION_SUGGESTED_UNITS
529: ,mil.rowid
530: from MTL_ITEM_LOCATIONS mil
531: ,MTL_SECONDARY_INVENTORIES msei
532: ,MTL_ITEM_SUB_INVENTORIES misi
533: where mil.organization_id(+) = msei.organization_id
534: and mil.organization_id=g_organization_id ---bug8425620 8665549

Line 657: from MTL_ITEM_LOCATIONS mil

653: ,mil.SUGGESTED_CUBIC_AREA
654: ,mil.SUGGESTED_WEIGHT
655: ,mil.LOCATION_SUGGESTED_UNITS
656: ,mil.rowid
657: from MTL_ITEM_LOCATIONS mil
658: ,MTL_SECONDARY_INVENTORIES msei
659: ,MTL_ITEM_SUB_INVENTORIES misi
660: where mil.organization_id(+) = msei.organization_id
661: and mil.organization_id=g_organization_id ---bug8425620 8665549

Line 786: from MTL_ITEM_LOCATIONS mil

782: ,mil.SUGGESTED_CUBIC_AREA
783: ,mil.SUGGESTED_WEIGHT
784: ,mil.LOCATION_SUGGESTED_UNITS
785: ,mil.rowid
786: from MTL_ITEM_LOCATIONS mil
787: ,MTL_SECONDARY_INVENTORIES msei
788: ,MTL_ITEM_SUB_INVENTORIES misi
789: where mil.organization_id(+) = msei.organization_id
790: and mil.organization_id=g_organization_id ---bug8425620 8665549

Line 917: from MTL_ITEM_LOCATIONS mil

913: ,mil.SUGGESTED_CUBIC_AREA
914: ,mil.SUGGESTED_WEIGHT
915: ,mil.LOCATION_SUGGESTED_UNITS
916: ,mil.rowid
917: from MTL_ITEM_LOCATIONS mil
918: ,MTL_SECONDARY_INVENTORIES msei
919: ,MTL_ITEM_SUB_INVENTORIES misi
920: ,MTL_SECONDARY_LOCATORS msl
921: where mil.organization_id = msei.organization_id

Line 1049: from MTL_ITEM_LOCATIONS mil

1045: ,mil.SUGGESTED_CUBIC_AREA
1046: ,mil.SUGGESTED_WEIGHT
1047: ,mil.LOCATION_SUGGESTED_UNITS
1048: ,mil.rowid
1049: from MTL_ITEM_LOCATIONS mil
1050: ,MTL_SECONDARY_INVENTORIES msei
1051: ,MTL_ITEM_SUB_INVENTORIES misi
1052: ,MTL_SECONDARY_LOCATORS msl
1053: where mil.organization_id = msei.organization_id

Line 1182: from MTL_ITEM_LOCATIONS mil

1178: ,mil.SUGGESTED_CUBIC_AREA
1179: ,mil.SUGGESTED_WEIGHT
1180: ,mil.LOCATION_SUGGESTED_UNITS
1181: ,mil.rowid
1182: from MTL_ITEM_LOCATIONS mil
1183: ,MTL_SECONDARY_INVENTORIES msei
1184: ,MTL_ITEM_SUB_INVENTORIES misi
1185: ,MTL_SECONDARY_LOCATORS msl
1186: where mil.organization_id = msei.organization_id