APPS.WMS_RULE_13 dependencies on MTL_SECONDARY_INVENTORIES

Line 153: ,MTL_SECONDARY_INVENTORIES msei

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
157: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 270: ,MTL_SECONDARY_INVENTORIES msei

266: ,mil.SUGGESTED_WEIGHT
267: ,mil.LOCATION_SUGGESTED_UNITS
268: ,mil.rowid
269: from MTL_ITEM_LOCATIONS mil
270: ,MTL_SECONDARY_INVENTORIES msei
271: where mil.organization_id(+) = msei.organization_id
272: and mil.subinventory_code(+) = msei.secondary_inventory_name
273: and NVL(msei.disable_date, sysdate+1) > sysdate
274: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 386: ,MTL_SECONDARY_INVENTORIES msei

382: ,mil.SUGGESTED_WEIGHT
383: ,mil.LOCATION_SUGGESTED_UNITS
384: ,mil.rowid
385: from MTL_ITEM_LOCATIONS mil
386: ,MTL_SECONDARY_INVENTORIES msei
387: where mil.organization_id(+) = msei.organization_id
388: and mil.subinventory_code(+) = msei.secondary_inventory_name
389: and NVL(msei.disable_date, sysdate+1) > sysdate
390: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 504: ,MTL_SECONDARY_INVENTORIES msei

500: ,mil.SUGGESTED_WEIGHT
501: ,mil.LOCATION_SUGGESTED_UNITS
502: ,mil.rowid
503: from MTL_ITEM_LOCATIONS mil
504: ,MTL_SECONDARY_INVENTORIES msei
505: ,MTL_ITEM_SUB_INVENTORIES misi
506: where mil.organization_id(+) = msei.organization_id
507: and mil.subinventory_code(+) = msei.secondary_inventory_name
508: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 622: ,MTL_SECONDARY_INVENTORIES msei

618: ,mil.SUGGESTED_WEIGHT
619: ,mil.LOCATION_SUGGESTED_UNITS
620: ,mil.rowid
621: from MTL_ITEM_LOCATIONS mil
622: ,MTL_SECONDARY_INVENTORIES msei
623: ,MTL_ITEM_SUB_INVENTORIES misi
624: where mil.organization_id(+) = msei.organization_id
625: and mil.subinventory_code(+) = msei.secondary_inventory_name
626: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 742: ,MTL_SECONDARY_INVENTORIES msei

738: ,mil.SUGGESTED_WEIGHT
739: ,mil.LOCATION_SUGGESTED_UNITS
740: ,mil.rowid
741: from MTL_ITEM_LOCATIONS mil
742: ,MTL_SECONDARY_INVENTORIES msei
743: ,MTL_ITEM_SUB_INVENTORIES misi
744: where mil.organization_id(+) = msei.organization_id
745: and mil.subinventory_code(+) = msei.secondary_inventory_name
746: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 864: ,MTL_SECONDARY_INVENTORIES msei

860: ,mil.SUGGESTED_WEIGHT
861: ,mil.LOCATION_SUGGESTED_UNITS
862: ,mil.rowid
863: from MTL_ITEM_LOCATIONS mil
864: ,MTL_SECONDARY_INVENTORIES msei
865: ,MTL_ITEM_SUB_INVENTORIES misi
866: ,MTL_SECONDARY_LOCATORS msl
867: where mil.organization_id = msei.organization_id
868: and mil.subinventory_code = msei.secondary_inventory_name

Line 987: ,MTL_SECONDARY_INVENTORIES msei

983: ,mil.SUGGESTED_WEIGHT
984: ,mil.LOCATION_SUGGESTED_UNITS
985: ,mil.rowid
986: from MTL_ITEM_LOCATIONS mil
987: ,MTL_SECONDARY_INVENTORIES msei
988: ,MTL_ITEM_SUB_INVENTORIES misi
989: ,MTL_SECONDARY_LOCATORS msl
990: where mil.organization_id = msei.organization_id
991: and mil.subinventory_code = msei.secondary_inventory_name

Line 1111: ,MTL_SECONDARY_INVENTORIES msei

1107: ,mil.SUGGESTED_WEIGHT
1108: ,mil.LOCATION_SUGGESTED_UNITS
1109: ,mil.rowid
1110: from MTL_ITEM_LOCATIONS mil
1111: ,MTL_SECONDARY_INVENTORIES msei
1112: ,MTL_ITEM_SUB_INVENTORIES misi
1113: ,MTL_SECONDARY_LOCATORS msl
1114: where mil.organization_id = msei.organization_id
1115: and mil.subinventory_code = msei.secondary_inventory_name