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 281: ,MTL_SECONDARY_INVENTORIES msei

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

Line 407: ,MTL_SECONDARY_INVENTORIES msei

403: ,mil.SUGGESTED_WEIGHT
404: ,mil.LOCATION_SUGGESTED_UNITS
405: ,mil.rowid
406: from MTL_ITEM_LOCATIONS mil
407: ,MTL_SECONDARY_INVENTORIES msei
408: where mil.organization_id(+) = msei.organization_id
409: and mil.subinventory_code(+) = msei.secondary_inventory_name
410: and NVL(msei.disable_date, sysdate+1) > sysdate
411: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 535: ,MTL_SECONDARY_INVENTORIES msei

531: ,mil.SUGGESTED_WEIGHT
532: ,mil.LOCATION_SUGGESTED_UNITS
533: ,mil.rowid
534: from MTL_ITEM_LOCATIONS mil
535: ,MTL_SECONDARY_INVENTORIES msei
536: ,MTL_ITEM_SUB_INVENTORIES misi
537: where mil.organization_id(+) = msei.organization_id
538: and mil.subinventory_code(+) = msei.secondary_inventory_name
539: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 663: ,MTL_SECONDARY_INVENTORIES msei

659: ,mil.SUGGESTED_WEIGHT
660: ,mil.LOCATION_SUGGESTED_UNITS
661: ,mil.rowid
662: from MTL_ITEM_LOCATIONS mil
663: ,MTL_SECONDARY_INVENTORIES msei
664: ,MTL_ITEM_SUB_INVENTORIES misi
665: where mil.organization_id(+) = msei.organization_id
666: and mil.subinventory_code(+) = msei.secondary_inventory_name
667: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 793: ,MTL_SECONDARY_INVENTORIES msei

789: ,mil.SUGGESTED_WEIGHT
790: ,mil.LOCATION_SUGGESTED_UNITS
791: ,mil.rowid
792: from MTL_ITEM_LOCATIONS mil
793: ,MTL_SECONDARY_INVENTORIES msei
794: ,MTL_ITEM_SUB_INVENTORIES misi
795: where mil.organization_id(+) = msei.organization_id
796: and mil.subinventory_code(+) = msei.secondary_inventory_name
797: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 925: ,MTL_SECONDARY_INVENTORIES msei

921: ,mil.SUGGESTED_WEIGHT
922: ,mil.LOCATION_SUGGESTED_UNITS
923: ,mil.rowid
924: from MTL_ITEM_LOCATIONS mil
925: ,MTL_SECONDARY_INVENTORIES msei
926: ,MTL_ITEM_SUB_INVENTORIES misi
927: ,MTL_SECONDARY_LOCATORS msl
928: where mil.organization_id = msei.organization_id
929: and mil.subinventory_code = msei.secondary_inventory_name

Line 1058: ,MTL_SECONDARY_INVENTORIES msei

1054: ,mil.SUGGESTED_WEIGHT
1055: ,mil.LOCATION_SUGGESTED_UNITS
1056: ,mil.rowid
1057: from MTL_ITEM_LOCATIONS mil
1058: ,MTL_SECONDARY_INVENTORIES msei
1059: ,MTL_ITEM_SUB_INVENTORIES misi
1060: ,MTL_SECONDARY_LOCATORS msl
1061: where mil.organization_id = msei.organization_id
1062: and mil.subinventory_code = msei.secondary_inventory_name

Line 1192: ,MTL_SECONDARY_INVENTORIES msei

1188: ,mil.SUGGESTED_WEIGHT
1189: ,mil.LOCATION_SUGGESTED_UNITS
1190: ,mil.rowid
1191: from MTL_ITEM_LOCATIONS mil
1192: ,MTL_SECONDARY_INVENTORIES msei
1193: ,MTL_ITEM_SUB_INVENTORIES misi
1194: ,MTL_SECONDARY_LOCATORS msl
1195: where mil.organization_id = msei.organization_id
1196: and mil.subinventory_code = msei.secondary_inventory_name