DBA Data[Home] [Help]

APPS.WMS_RULE_7 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 526: ,MTL_ITEM_SUB_INVENTORIES misi

522: ,mil.LOCATION_SUGGESTED_UNITS
523: ,mil.rowid
524: from MTL_ITEM_LOCATIONS mil
525: ,MTL_SECONDARY_INVENTORIES msei
526: ,MTL_ITEM_SUB_INVENTORIES misi
527: where mil.organization_id(+) = msei.organization_id
528: and mil.subinventory_code(+) = msei.secondary_inventory_name
529: and NVL(msei.disable_date, sysdate+1) > sysdate
530: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 651: ,MTL_ITEM_SUB_INVENTORIES misi

647: ,mil.LOCATION_SUGGESTED_UNITS
648: ,mil.rowid
649: from MTL_ITEM_LOCATIONS mil
650: ,MTL_SECONDARY_INVENTORIES msei
651: ,MTL_ITEM_SUB_INVENTORIES misi
652: where mil.organization_id(+) = msei.organization_id
653: and mil.subinventory_code(+) = msei.secondary_inventory_name
654: and NVL(msei.disable_date, sysdate+1) > sysdate
655: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 778: ,MTL_ITEM_SUB_INVENTORIES misi

774: ,mil.LOCATION_SUGGESTED_UNITS
775: ,mil.rowid
776: from MTL_ITEM_LOCATIONS mil
777: ,MTL_SECONDARY_INVENTORIES msei
778: ,MTL_ITEM_SUB_INVENTORIES misi
779: where mil.organization_id(+) = msei.organization_id
780: and mil.subinventory_code(+) = msei.secondary_inventory_name
781: and NVL(msei.disable_date, sysdate+1) > sysdate
782: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 907: ,MTL_ITEM_SUB_INVENTORIES misi

903: ,mil.LOCATION_SUGGESTED_UNITS
904: ,mil.rowid
905: from MTL_ITEM_LOCATIONS mil
906: ,MTL_SECONDARY_INVENTORIES msei
907: ,MTL_ITEM_SUB_INVENTORIES misi
908: ,MTL_SECONDARY_LOCATORS msl
909: where mil.organization_id = msei.organization_id
910: and mil.subinventory_code = msei.secondary_inventory_name
911: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1037: ,MTL_ITEM_SUB_INVENTORIES misi

1033: ,mil.LOCATION_SUGGESTED_UNITS
1034: ,mil.rowid
1035: from MTL_ITEM_LOCATIONS mil
1036: ,MTL_SECONDARY_INVENTORIES msei
1037: ,MTL_ITEM_SUB_INVENTORIES misi
1038: ,MTL_SECONDARY_LOCATORS msl
1039: where mil.organization_id = msei.organization_id
1040: and mil.subinventory_code = msei.secondary_inventory_name
1041: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1168: ,MTL_ITEM_SUB_INVENTORIES misi

1164: ,mil.LOCATION_SUGGESTED_UNITS
1165: ,mil.rowid
1166: from MTL_ITEM_LOCATIONS mil
1167: ,MTL_SECONDARY_INVENTORIES msei
1168: ,MTL_ITEM_SUB_INVENTORIES misi
1169: ,MTL_SECONDARY_LOCATORS msl
1170: where mil.organization_id = msei.organization_id
1171: and mil.subinventory_code = msei.secondary_inventory_name
1172: and NVL(msei.disable_date, sysdate+1) > sysdate